Dataset statistics
| Number of variables | 36 |
|---|---|
| Number of observations | 588053 |
| Missing cells | 2085003 |
| Missing cells (%) | 9.8% |
| Duplicate rows | 963 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 161.5 MiB |
| Average record size in memory | 288.0 B |
Variable types
| Categorical | 25 |
|---|---|
| Numeric | 10 |
| Unsupported | 1 |
AsOfDate has constant value "20200930" | Constant |
Program has constant value "7A" | Constant |
| Dataset has 963 (0.2%) duplicate rows | Duplicates |
BorrName has a high cardinality: 477025 distinct values | High cardinality |
BorrStreet has a high cardinality: 510557 distinct values | High cardinality |
BorrCity has a high cardinality: 26981 distinct values | High cardinality |
BorrState has a high cardinality: 58 distinct values | High cardinality |
BankName has a high cardinality: 3258 distinct values | High cardinality |
BankStreet has a high cardinality: 3469 distinct values | High cardinality |
BankCity has a high cardinality: 2184 distinct values | High cardinality |
BankState has a high cardinality: 55 distinct values | High cardinality |
ApprovalDate has a high cardinality: 3761 distinct values | High cardinality |
FirstDisbursementDate has a high cardinality: 3530 distinct values | High cardinality |
NaicsDescription has a high cardinality: 1220 distinct values | High cardinality |
FranchiseCode has a high cardinality: 5444 distinct values | High cardinality |
FranchiseName has a high cardinality: 4768 distinct values | High cardinality |
ProjectCounty has a high cardinality: 1889 distinct values | High cardinality |
ProjectState has a high cardinality: 58 distinct values | High cardinality |
SBADistrictOffice has a high cardinality: 74 distinct values | High cardinality |
PaidInFullDate has a high cardinality: 130 distinct values | High cardinality |
ChargeOffDate has a high cardinality: 2184 distinct values | High cardinality |
BorrZip is highly overall correlated with BorrState and 3 other fields | High correlation |
GrossApproval is highly overall correlated with SBAGuaranteedApproval and 1 other fields | High correlation |
SBAGuaranteedApproval is highly overall correlated with GrossApproval and 1 other fields | High correlation |
TermInMonths is highly overall correlated with GrossApproval and 1 other fields | High correlation |
CongressionalDistrict is highly overall correlated with SBADistrictOffice | High correlation |
BorrState is highly overall correlated with BorrZip and 3 other fields | High correlation |
BankState is highly overall correlated with BorrZip and 3 other fields | High correlation |
DeliveryMethod is highly overall correlated with subpgmdesc and 1 other fields | High correlation |
subpgmdesc is highly overall correlated with DeliveryMethod and 1 other fields | High correlation |
ProjectState is highly overall correlated with BorrZip and 3 other fields | High correlation |
SBADistrictOffice is highly overall correlated with BorrZip and 4 other fields | High correlation |
RevolverStatus is highly overall correlated with DeliveryMethod and 1 other fields | High correlation |
DeliveryMethod is highly imbalanced (50.3%) | Imbalance |
subpgmdesc is highly imbalanced (59.8%) | Imbalance |
BusinessType is highly imbalanced (61.6%) | Imbalance |
FirstDisbursementDate has 82091 (14.0%) missing values | Missing |
FranchiseCode has 534676 (90.9%) missing values | Missing |
FranchiseName has 534790 (90.9%) missing values | Missing |
PaidInFullDate has 365212 (62.1%) missing values | Missing |
ChargeOffDate has 567384 (96.5%) missing values | Missing |
GrossChargeOffAmount is highly skewed (γ1 = 29.43380104) | Skewed |
BorrName is uniformly distributed | Uniform |
BorrStreet is uniformly distributed | Uniform |
BankZip is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CongressionalDistrict has 19793 (3.4%) zeros | Zeros |
GrossChargeOffAmount has 567384 (96.5%) zeros | Zeros |
JobsSupported has 93989 (16.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-03-20 13:15:38.489317 |
|---|---|
| Analysis finished | 2023-03-20 13:17:21.193447 |
| Duration | 1 minute and 42.7 seconds |
| Software version | pandas-profiling v0.0.dev0 |
| Download configuration | config.json |
AsOfDate
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 20200930 |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 4704424 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 20200930 |
|---|---|
| 2nd row | 20200930 |
| 3rd row | 20200930 |
| 4th row | 20200930 |
| 5th row | 20200930 |
Common Values
| Value | Count | Frequency (%) |
| 20200930 | 588053 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 20200930 | 588053 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2352212 | |
| 2 | 1176106 | |
| 9 | 588053 | 12.5% |
| 3 | 588053 | 12.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4704424 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2352212 | |
| 2 | 1176106 | |
| 9 | 588053 | 12.5% |
| 3 | 588053 | 12.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4704424 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2352212 | |
| 2 | 1176106 | |
| 9 | 588053 | 12.5% |
| 3 | 588053 | 12.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4704424 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2352212 | |
| 2 | 1176106 | |
| 9 | 588053 | 12.5% |
| 3 | 588053 | 12.5% |
Program
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 7A |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1176106 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7A |
|---|---|
| 2nd row | 7A |
| 3rd row | 7A |
| 4th row | 7A |
| 5th row | 7A |
Common Values
| Value | Count | Frequency (%) |
| 7A | 588053 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 7a | 588053 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 588053 | |
| A | 588053 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 588053 | |
| Uppercase Letter | 588053 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 588053 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 588053 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 588053 | |
| Latin | 588053 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 588053 |
Latin
| Value | Count | Frequency (%) |
| A | 588053 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1176106 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 588053 | |
| A | 588053 |
BorrName
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 477025 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 37 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| Entity to be formed | 45 |
|---|---|
| The Cove at River Oaks, LLC | 42 |
| Anytime Fitness | 42 |
| Sport Clips | 37 |
| Subway | 34 |
| Other values (477020) |
Length
| Max length | 30 |
|---|---|
| Median length | 23 |
| Mean length | 21.91991 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12889258 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 12 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 394960 ? |
|---|---|
| Unique (%) | 67.2% |
Sample
| 1st row | CRESA PARTNERS - DENVER, INC. |
|---|---|
| 2nd row | The Hilltop Tavern |
| 3rd row | River City Car Wash LLC |
| 4th row | Alphagraphics |
| 5th row | ON SITE AUTOMOTIVE APPEARANCE |
Common Values
| Value | Count | Frequency (%) |
| Entity to be formed | 45 | < 0.1% |
| The Cove at River Oaks, LLC | 42 | < 0.1% |
| Anytime Fitness | 42 | < 0.1% |
| Sport Clips | 37 | < 0.1% |
| Subway | 34 | < 0.1% |
| Briar Rose Estates, LLC | 33 | < 0.1% |
| HARDRIVES CONSTRUCTION INC | 24 | < 0.1% |
| Silly Zak's Gluten Free Bakery | 21 | < 0.1% |
| Vision Logistics Inc. | 18 | < 0.1% |
| Rock River Laboratory, Inc. | 18 | < 0.1% |
| Other values (477015) | 587702 | |
| (Missing) | 37 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| llc | 212975 | 10.2% |
| inc | 157989 | 7.6% |
| 43744 | 2.1% | |
| and | 23507 | 1.1% |
| enterprises | 15347 | 0.7% |
| group | 14758 | 0.7% |
| services | 14464 | 0.7% |
| the | 13915 | 0.7% |
| of | 11126 | 0.5% |
| company | 9974 | 0.5% |
| Other values (175762) | 1568671 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1500385 | 11.6% | |
| e | 680673 | 5.3% |
| L | 648760 | 5.0% |
| n | 613572 | 4.8% |
| C | 549330 | 4.3% |
| a | 542809 | 4.2% |
| r | 509387 | 4.0% |
| i | 484366 | 3.8% |
| o | 472812 | 3.7% |
| t | 413909 | 3.2% |
| Other values (84) | 6473255 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5983217 | |
| Uppercase Letter | 4842952 | |
| Space Separator | 1500385 | 11.6% |
| Other Punctuation | 498744 | 3.9% |
| Decimal Number | 46171 | 0.4% |
| Dash Punctuation | 13186 | 0.1% |
| Open Punctuation | 2381 | < 0.1% |
| Close Punctuation | 1851 | < 0.1% |
| Math Symbol | 314 | < 0.1% |
| Modifier Symbol | 20 | < 0.1% |
| Other values (2) | 37 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 680673 | |
| n | 613572 | |
| a | 542809 | |
| r | 509387 | 8.5% |
| i | 484366 | 8.1% |
| o | 472812 | 7.9% |
| t | 413909 | 6.9% |
| s | 380909 | 6.4% |
| c | 306531 | 5.1% |
| l | 291045 | 4.9% |
| Other values (17) | 1287204 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 648760 | |
| C | 549330 | |
| I | 400320 | 8.3% |
| S | 326625 | 6.7% |
| E | 321354 | 6.6% |
| A | 310180 | 6.4% |
| R | 266426 | 5.5% |
| N | 266212 | 5.5% |
| T | 253978 | 5.2% |
| O | 205620 | 4.2% |
| Other values (16) | 1294147 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 239296 | |
| . | 179243 | |
| & | 50555 | 10.1% |
| ' | 22102 | 4.4% |
| ; | 3166 | 0.6% |
| / | 2516 | 0.5% |
| # | 853 | 0.2% |
| : | 389 | 0.1% |
| ? | 256 | 0.1% |
| ! | 237 | < 0.1% |
| Other values (5) | 131 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8756 | |
| 2 | 8156 | |
| 3 | 5531 | |
| 0 | 5315 | |
| 4 | 4571 | |
| 5 | 3669 | |
| 6 | 2649 | 5.7% |
| 8 | 2595 | 5.6% |
| 9 | 2474 | 5.4% |
| 7 | 2455 | 5.3% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 299 | |
| > | 7 | 2.2% |
| < | 4 | 1.3% |
| = | 3 | 1.0% |
| | | 1 | 0.3% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2371 | |
| [ | 9 | 0.4% |
| { | 1 | < 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1843 | |
| ] | 8 | 0.4% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 18 | |
| ^ | 2 | 10.0% |
Space Separator
| Value | Count | Frequency (%) |
| 1500385 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13186 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 19 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 18 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10826169 | |
| Common | 2063089 | 16.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 680673 | 6.3% |
| L | 648760 | 6.0% |
| n | 613572 | 5.7% |
| C | 549330 | 5.1% |
| a | 542809 | 5.0% |
| r | 509387 | 4.7% |
| i | 484366 | 4.5% |
| o | 472812 | 4.4% |
| t | 413909 | 3.8% |
| I | 400320 | 3.7% |
| Other values (43) | 5510231 |
Common
| Value | Count | Frequency (%) |
| 1500385 | ||
| , | 239296 | 11.6% |
| . | 179243 | 8.7% |
| & | 50555 | 2.5% |
| ' | 22102 | 1.1% |
| - | 13186 | 0.6% |
| 1 | 8756 | 0.4% |
| 2 | 8156 | 0.4% |
| 3 | 5531 | 0.3% |
| 0 | 5315 | 0.3% |
| Other values (31) | 30564 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12889257 | |
| None | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1500385 | 11.6% | |
| e | 680673 | 5.3% |
| L | 648760 | 5.0% |
| n | 613572 | 4.8% |
| C | 549330 | 4.3% |
| a | 542809 | 4.2% |
| r | 509387 | 4.0% |
| i | 484366 | 3.8% |
| o | 472812 | 3.7% |
| t | 413909 | 3.2% |
| Other values (83) | 6473254 |
None
| Value | Count | Frequency (%) |
| ú | 1 |
BorrStreet
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 510557 |
|---|---|
| Distinct (%) | 86.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| TBD | 67 |
|---|---|
| Main Street | 45 |
| 1111 Parana | 24 |
| PO BOX | 18 |
| Main St | 17 |
| Other values (510552) |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 19.306285 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11353119 |
|---|---|
| Distinct characters | 87 |
| Distinct categories | 12 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 448838 ? |
|---|---|
| Unique (%) | 76.3% |
Sample
| 1st row | 7979 E TUFTS AVE PKWY STE 810 |
|---|---|
| 2nd row | 4757 Folsom Blvd |
| 3rd row | 649 Harbor Blvd |
| 4th row | 71 Newtown Road. |
| 5th row | 603 WOODBRIDGE COURT |
Common Values
| Value | Count | Frequency (%) |
| TBD | 67 | < 0.1% |
| Main Street | 45 | < 0.1% |
| 1111 Parana | 24 | < 0.1% |
| PO BOX | 18 | < 0.1% |
| Main St | 17 | < 0.1% |
| MAIN ST | 15 | < 0.1% |
| 21107 Omega Circle | 15 | < 0.1% |
| 2781 Kikihau St | 15 | < 0.1% |
| 400 Hana Highway A1 | 14 | < 0.1% |
| 7207 CANTERWOOD PL | 14 | < 0.1% |
| Other values (510547) | 587809 |
Length
| Value | Count | Frequency (%) |
| st | 71502 | 3.1% |
| street | 65691 | 2.9% |
| ave | 64589 | 2.8% |
| rd | 56175 | 2.5% |
| road | 55062 | 2.4% |
| suite | 38234 | 1.7% |
| dr | 34927 | 1.5% |
| w | 32453 | 1.4% |
| n | 31993 | 1.4% |
| s | 31946 | 1.4% |
| Other values (93873) | 1796979 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1696023 | 14.9% | |
| e | 593794 | 5.2% |
| 1 | 490793 | 4.3% |
| t | 432535 | 3.8% |
| 0 | 383839 | 3.4% |
| S | 381283 | 3.4% |
| a | 349288 | 3.1% |
| r | 336053 | 3.0% |
| 2 | 322438 | 2.8% |
| E | 289771 | 2.6% |
| Other values (77) | 6077302 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3829869 | |
| Uppercase Letter | 3126859 | |
| Decimal Number | 2530562 | |
| Space Separator | 1696023 | |
| Other Punctuation | 155841 | 1.4% |
| Dash Punctuation | 13636 | 0.1% |
| Open Punctuation | 175 | < 0.1% |
| Close Punctuation | 93 | < 0.1% |
| Modifier Symbol | 24 | < 0.1% |
| Math Symbol | 15 | < 0.1% |
| Other values (2) | 22 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 593794 | |
| t | 432535 | |
| a | 349288 | |
| r | 336053 | |
| o | 276569 | 7.2% |
| n | 260969 | 6.8% |
| i | 254439 | 6.6% |
| l | 195079 | 5.1% |
| d | 190308 | 5.0% |
| u | 141834 | 3.7% |
| Other values (16) | 799001 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 381283 | |
| E | 289771 | 9.3% |
| R | 285348 | 9.1% |
| A | 275181 | 8.8% |
| T | 197979 | 6.3% |
| N | 184559 | 5.9% |
| D | 174870 | 5.6% |
| L | 145024 | 4.6% |
| W | 133325 | 4.3% |
| C | 125606 | 4.0% |
| Other values (16) | 933913 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 104621 | |
| , | 26781 | 17.2% |
| # | 19031 | 12.2% |
| & | 3439 | 2.2% |
| / | 1054 | 0.7% |
| ' | 571 | 0.4% |
| ; | 181 | 0.1% |
| ? | 113 | 0.1% |
| : | 25 | < 0.1% |
| @ | 14 | < 0.1% |
| Other values (3) | 11 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 490793 | |
| 0 | 383839 | |
| 2 | 322438 | |
| 5 | 246514 | |
| 3 | 246295 | |
| 4 | 215262 | |
| 6 | 171167 | 6.8% |
| 7 | 162564 | 6.4% |
| 8 | 149007 | 5.9% |
| 9 | 142683 | 5.6% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 11 | |
| = | 2 | 13.3% |
| < | 1 | 6.7% |
| > | 1 | 6.7% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 22 | |
| ^ | 2 | 8.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1696023 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13636 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 175 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 93 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 14 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6956728 | |
| Common | 4396391 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 593794 | 8.5% |
| t | 432535 | 6.2% |
| S | 381283 | 5.5% |
| a | 349288 | 5.0% |
| r | 336053 | 4.8% |
| E | 289771 | 4.2% |
| R | 285348 | 4.1% |
| o | 276569 | 4.0% |
| A | 275181 | 4.0% |
| n | 260969 | 3.8% |
| Other values (42) | 3475937 |
Common
| Value | Count | Frequency (%) |
| 1696023 | ||
| 1 | 490793 | 11.2% |
| 0 | 383839 | 8.7% |
| 2 | 322438 | 7.3% |
| 5 | 246514 | 5.6% |
| 3 | 246295 | 5.6% |
| 4 | 215262 | 4.9% |
| 6 | 171167 | 3.9% |
| 7 | 162564 | 3.7% |
| 8 | 149007 | 3.4% |
| Other values (25) | 312489 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11353119 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1696023 | 14.9% | |
| e | 593794 | 5.2% |
| 1 | 490793 | 4.3% |
| t | 432535 | 3.8% |
| 0 | 383839 | 3.4% |
| S | 381283 | 3.4% |
| a | 349288 | 3.1% |
| r | 336053 | 3.0% |
| 2 | 322438 | 2.8% |
| E | 289771 | 2.6% |
| Other values (77) | 6077302 |
BorrCity
Categorical
| Distinct | 26981 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| LOS ANGELES | 4451 |
|---|---|
| HOUSTON | 3858 |
| NEW YORK | 3356 |
| CHICAGO | 2965 |
| BROOKLYN | 2404 |
| Other values (26976) |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 8.8787014 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5221147 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8160 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | DENVER |
|---|---|
| 2nd row | Sacramento |
| 3rd row | West Sacramento |
| 4th row | Danbury |
| 5th row | MIDDLEBURY |
Common Values
| Value | Count | Frequency (%) |
| LOS ANGELES | 4451 | 0.8% |
| HOUSTON | 3858 | 0.7% |
| NEW YORK | 3356 | 0.6% |
| CHICAGO | 2965 | 0.5% |
| BROOKLYN | 2404 | 0.4% |
| SAN DIEGO | 2213 | 0.4% |
| DENVER | 2200 | 0.4% |
| DALLAS | 2106 | 0.4% |
| LAS VEGAS | 1988 | 0.3% |
| PORTLAND | 1968 | 0.3% |
| Other values (26971) | 560544 |
Length
| Value | Count | Frequency (%) |
| city | 14248 | 1.9% |
| san | 13124 | 1.7% |
| new | 9388 | 1.2% |
| beach | 6862 | 0.9% |
| park | 6820 | 0.9% |
| lake | 6700 | 0.9% |
| los | 6668 | 0.9% |
| angeles | 6360 | 0.8% |
| houston | 5789 | 0.8% |
| fort | 5499 | 0.7% |
| Other values (12448) | 681210 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 331257 | 6.3% |
| E | 302588 | 5.8% |
| N | 272567 | 5.2% |
| O | 266799 | 5.1% |
| L | 258577 | 5.0% |
| R | 222752 | 4.3% |
| S | 218519 | 4.2% |
| I | 197836 | 3.8% |
| e | 185021 | 3.5% |
| T | 181114 | 3.5% |
| Other values (66) | 2784117 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3346837 | |
| Lowercase Letter | 1695400 | |
| Space Separator | 174654 | 3.3% |
| Other Punctuation | 2286 | < 0.1% |
| Open Punctuation | 812 | < 0.1% |
| Decimal Number | 543 | < 0.1% |
| Close Punctuation | 500 | < 0.1% |
| Dash Punctuation | 114 | < 0.1% |
| Modifier Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 331257 | 9.9% |
| E | 302588 | 9.0% |
| N | 272567 | 8.1% |
| O | 266799 | 8.0% |
| L | 258577 | 7.7% |
| R | 222752 | 6.7% |
| S | 218519 | 6.5% |
| I | 197836 | 5.9% |
| T | 181114 | 5.4% |
| C | 137672 | 4.1% |
| Other values (16) | 957156 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 185021 | |
| a | 178448 | |
| n | 157881 | |
| o | 157541 | |
| l | 137810 | 8.1% |
| i | 127018 | 7.5% |
| r | 125874 | 7.4% |
| t | 107256 | 6.3% |
| s | 90458 | 5.3% |
| d | 55336 | 3.3% |
| Other values (16) | 372757 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 104 | |
| 1 | 78 | |
| 0 | 70 | |
| 2 | 62 | |
| 3 | 54 | |
| 5 | 41 | 7.6% |
| 9 | 38 | 7.0% |
| 6 | 36 | 6.6% |
| 7 | 33 | 6.1% |
| 8 | 27 | 5.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1601 | |
| , | 413 | 18.1% |
| ' | 221 | 9.7% |
| ? | 18 | 0.8% |
| / | 16 | 0.7% |
| & | 8 | 0.3% |
| ; | 3 | 0.1% |
| # | 3 | 0.1% |
| : | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 174654 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 812 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 500 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 114 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5042237 | |
| Common | 178910 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 331257 | 6.6% |
| E | 302588 | 6.0% |
| N | 272567 | 5.4% |
| O | 266799 | 5.3% |
| L | 258577 | 5.1% |
| R | 222752 | 4.4% |
| S | 218519 | 4.3% |
| I | 197836 | 3.9% |
| e | 185021 | 3.7% |
| T | 181114 | 3.6% |
| Other values (42) | 2605207 |
Common
| Value | Count | Frequency (%) |
| 174654 | ||
| . | 1601 | 0.9% |
| ( | 812 | 0.5% |
| ) | 500 | 0.3% |
| , | 413 | 0.2% |
| ' | 221 | 0.1% |
| - | 114 | 0.1% |
| 4 | 104 | 0.1% |
| 1 | 78 | < 0.1% |
| 0 | 70 | < 0.1% |
| Other values (14) | 343 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5221147 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 331257 | 6.3% |
| E | 302588 | 5.8% |
| N | 272567 | 5.2% |
| O | 266799 | 5.1% |
| L | 258577 | 5.0% |
| R | 222752 | 4.3% |
| S | 218519 | 4.2% |
| I | 197836 | 3.8% |
| e | 185021 | 3.5% |
| T | 181114 | 3.5% |
| Other values (66) | 2784117 |
BorrState
Categorical
HIGH CARDINALITY  HIGH CORRELATION 
| Distinct | 58 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| CA | |
|---|---|
| TX | |
| NY | |
| OH | 33449 |
| FL | 28681 |
| Other values (53) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1176106 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CO |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CT |
| 5th row | IN |
Common Values
| Value | Count | Frequency (%) |
| CA | 73442 | 12.5% |
| TX | 44854 | 7.6% |
| NY | 37443 | 6.4% |
| OH | 33449 | 5.7% |
| FL | 28681 | 4.9% |
| MI | 22977 | 3.9% |
| MA | 20755 | 3.5% |
| IL | 19445 | 3.3% |
| PA | 18836 | 3.2% |
| MN | 16981 | 2.9% |
| Other values (48) | 271190 |
Length
| Value | Count | Frequency (%) |
| ca | 73442 | 12.5% |
| tx | 44854 | 7.6% |
| ny | 37443 | 6.4% |
| oh | 33449 | 5.7% |
| fl | 28681 | 4.9% |
| mi | 22977 | 3.9% |
| ma | 20755 | 3.5% |
| il | 19445 | 3.3% |
| pa | 18836 | 3.2% |
| mn | 16981 | 2.9% |
| Other values (48) | 271190 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 183967 | |
| N | 119588 | |
| C | 111834 | 9.5% |
| M | 94419 | 8.0% |
| I | 87937 | 7.5% |
| T | 74089 | 6.3% |
| O | 72655 | 6.2% |
| L | 56887 | 4.8% |
| X | 44854 | 3.8% |
| Y | 43944 | 3.7% |
| Other values (14) | 285932 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1176106 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 183967 | |
| N | 119588 | |
| C | 111834 | 9.5% |
| M | 94419 | 8.0% |
| I | 87937 | 7.5% |
| T | 74089 | 6.3% |
| O | 72655 | 6.2% |
| L | 56887 | 4.8% |
| X | 44854 | 3.8% |
| Y | 43944 | 3.7% |
| Other values (14) | 285932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1176106 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 183967 | |
| N | 119588 | |
| C | 111834 | 9.5% |
| M | 94419 | 8.0% |
| I | 87937 | 7.5% |
| T | 74089 | 6.3% |
| O | 72655 | 6.2% |
| L | 56887 | 4.8% |
| X | 44854 | 3.8% |
| Y | 43944 | 3.7% |
| Other values (14) | 285932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1176106 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 183967 | |
| N | 119588 | |
| C | 111834 | 9.5% |
| M | 94419 | 8.0% |
| I | 87937 | 7.5% |
| T | 74089 | 6.3% |
| O | 72655 | 6.2% |
| L | 56887 | 4.8% |
| X | 44854 | 3.8% |
| Y | 43944 | 3.7% |
| Other values (14) | 285932 |
BorrZip
Real number (ℝ)
| Distinct | 24334 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52318.167 |
| Minimum | 601 |
|---|---|
| Maximum | 99929 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 601 |
|---|---|
| 5-th percentile | 3031 |
| Q1 | 27954 |
| median | 50613 |
| Q3 | 80238 |
| 95-th percentile | 96150 |
| Maximum | 99929 |
| Range | 99328 |
| Interquartile range (IQR) | 52284 |
Descriptive statistics
| Standard deviation | 30775.38 |
|---|---|
| Coefficient of variation (CV) | 0.58823506 |
| Kurtosis | -1.2879899 |
| Mean | 52318.167 |
| Median Absolute Deviation (MAD) | 28141 |
| Skewness | -0.083580435 |
| Sum | 3.0765855 × 1010 |
| Variance | 9.47124 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10001 | 540 | 0.1% |
| 90021 | 414 | 0.1% |
| 75034 | 395 | 0.1% |
| 33166 | 371 | 0.1% |
| 93401 | 355 | 0.1% |
| 46032 | 352 | 0.1% |
| 10018 | 349 | 0.1% |
| 85260 | 345 | 0.1% |
| 90015 | 341 | 0.1% |
| 84115 | 335 | 0.1% |
| Other values (24324) | 584256 |
| Value | Count | Frequency (%) |
| 601 | 10 | < 0.1% |
| 602 | 64 | |
| 603 | 93 | |
| 604 | 2 | < 0.1% |
| 605 | 14 | < 0.1% |
| 606 | 2 | < 0.1% |
| 610 | 44 | |
| 612 | 73 | |
| 613 | 2 | < 0.1% |
| 614 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 99929 | 3 | < 0.1% |
| 99925 | 3 | < 0.1% |
| 99921 | 7 | < 0.1% |
| 99919 | 1 | < 0.1% |
| 99901 | 54 | |
| 99841 | 1 | < 0.1% |
| 99840 | 16 | < 0.1% |
| 99835 | 27 | |
| 99833 | 8 | < 0.1% |
| 99832 | 5 | < 0.1% |
BankName
Categorical
| Distinct | 3258 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| Wells Fargo Bank, National Association | |
|---|---|
| The Huntington National Bank | 38631 |
| JPMorgan Chase Bank, National Association | 36302 |
| U.S. Bank, National Association | 27943 |
| TD Bank, National Association | 16908 |
| Other values (3253) |
Length
| Max length | 60 |
|---|---|
| Median length | 50 |
| Mean length | 25.526407 |
| Min length | 3 |
Characters and Unicode
| Total characters | 15010880 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 445 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Zions Bank, A Division of |
|---|---|
| 2nd row | Plumas Bank |
| 3rd row | Wells Fargo Bank, National Association |
| 4th row | Union Savings Bank |
| 5th row | VelocitySBA, LLC |
Common Values
| Value | Count | Frequency (%) |
| Wells Fargo Bank, National Association | 46635 | 7.9% |
| The Huntington National Bank | 38631 | 6.6% |
| JPMorgan Chase Bank, National Association | 36302 | 6.2% |
| U.S. Bank, National Association | 27943 | 4.8% |
| TD Bank, National Association | 16908 | 2.9% |
| Manufacturers and Traders Trust Company | 13877 | 2.4% |
| BBVA USA | 11992 | 2.0% |
| Celtic Bank Corporation | 8811 | 1.5% |
| Live Oak Banking Company | 8565 | 1.5% |
| Truist Bank d/b/a Branch Banking & Trust Co | 8279 | 1.4% |
| Other values (3248) | 370110 |
Length
| Value | Count | Frequency (%) |
| bank | 481364 | |
| national | 245889 | 11.3% |
| association | 186924 | 8.6% |
| the | 53049 | 2.4% |
| fargo | 46690 | 2.2% |
| wells | 46644 | 2.1% |
| of | 43280 | 2.0% |
| trust | 41643 | 1.9% |
| huntington | 38631 | 1.8% |
| chase | 36302 | 1.7% |
| Other values (2239) | 949400 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1737693 | 11.6% |
| 1581857 | 10.5% | |
| n | 1542405 | 10.3% |
| i | 1084555 | 7.2% |
| o | 1073535 | 7.2% |
| t | 883163 | 5.9% |
| s | 787292 | 5.2% |
| B | 608361 | 4.1% |
| e | 575456 | 3.8% |
| k | 551047 | 3.7% |
| Other values (65) | 4585516 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 10701953 | |
| Uppercase Letter | 2397225 | 16.0% |
| Space Separator | 1581857 | 10.5% |
| Other Punctuation | 322605 | 2.1% |
| Decimal Number | 4322 | < 0.1% |
| Dash Punctuation | 2331 | < 0.1% |
| Open Punctuation | 284 | < 0.1% |
| Close Punctuation | 284 | < 0.1% |
| Math Symbol | 19 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1737693 | |
| n | 1542405 | |
| i | 1084555 | |
| o | 1073535 | |
| t | 883163 | |
| s | 787292 | |
| e | 575456 | 5.4% |
| k | 551047 | 5.1% |
| l | 474548 | 4.4% |
| r | 451393 | 4.2% |
| Other values (16) | 1540866 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 608361 | |
| N | 274017 | |
| A | 253137 | |
| C | 221792 | 9.3% |
| T | 147367 | 6.1% |
| F | 136670 | 5.7% |
| S | 135201 | 5.6% |
| U | 80087 | 3.3% |
| P | 77080 | 3.2% |
| M | 76859 | 3.2% |
| Other values (16) | 386654 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2975 | |
| 2 | 549 | 12.7% |
| 3 | 198 | 4.6% |
| 0 | 194 | 4.5% |
| 4 | 164 | 3.8% |
| 5 | 112 | 2.6% |
| 6 | 89 | 2.1% |
| 7 | 23 | 0.5% |
| 8 | 18 | 0.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 207675 | |
| . | 73937 | 22.9% |
| / | 19259 | 6.0% |
| & | 18580 | 5.8% |
| ' | 3150 | 1.0% |
| \ | 2 | < 0.1% |
| " | 2 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 9 | |
| < | 5 | |
| > | 5 |
Space Separator
| Value | Count | Frequency (%) |
| 1581857 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2331 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 284 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 284 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13099178 | |
| Common | 1911702 | 12.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1737693 | |
| n | 1542405 | |
| i | 1084555 | 8.3% |
| o | 1073535 | 8.2% |
| t | 883163 | 6.7% |
| s | 787292 | 6.0% |
| B | 608361 | 4.6% |
| e | 575456 | 4.4% |
| k | 551047 | 4.2% |
| l | 474548 | 3.6% |
| Other values (42) | 3781123 |
Common
| Value | Count | Frequency (%) |
| 1581857 | ||
| , | 207675 | 10.9% |
| . | 73937 | 3.9% |
| / | 19259 | 1.0% |
| & | 18580 | 1.0% |
| ' | 3150 | 0.2% |
| 1 | 2975 | 0.2% |
| - | 2331 | 0.1% |
| 2 | 549 | < 0.1% |
| ( | 284 | < 0.1% |
| Other values (13) | 1105 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15010880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1737693 | 11.6% |
| 1581857 | 10.5% | |
| n | 1542405 | 10.3% |
| i | 1084555 | 7.2% |
| o | 1073535 | 7.2% |
| t | 883163 | 5.9% |
| s | 787292 | 5.2% |
| B | 608361 | 4.1% |
| e | 575456 | 3.8% |
| k | 551047 | 3.7% |
| Other values (65) | 4585516 |
BankStreet
Categorical
| Distinct | 3469 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| 101 N Philips Ave | |
|---|---|
| 17 S High St | 38631 |
| 1111 Polaris Pkwy | 36302 |
| 425 Walnut St | 27943 |
| 2035 Limestone Rd | 16908 |
| Other values (3464) |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 16.855216 |
| Min length | 8 |
Characters and Unicode
| Total characters | 9911693 |
|---|---|
| Distinct characters | 74 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 477 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 1 S Main St |
|---|---|
| 2nd row | 336 W Main St |
| 3rd row | 101 N Philips Ave |
| 4th row | 226 Main St |
| 5th row | 9385 Haven Avenue |
Common Values
| Value | Count | Frequency (%) |
| 101 N Philips Ave | 46635 | 7.9% |
| 17 S High St | 38631 | 6.6% |
| 1111 Polaris Pkwy | 36302 | 6.2% |
| 425 Walnut St | 27943 | 4.8% |
| 2035 Limestone Rd | 16908 | 2.9% |
| One M & T Plaza, 15th Fl | 13877 | 2.4% |
| 15 S 20th St | 11992 | 2.0% |
| 268 S State St, Ste 300 | 8811 | 1.5% |
| 1741 Tiburon Dr | 8565 | 1.5% |
| 214 N Tryon St | 8279 | 1.4% |
| Other values (3459) | 370106 |
Length
| Value | Count | Frequency (%) |
| st | 254015 | 11.2% |
| ave | 101252 | 4.4% |
| n | 100419 | 4.4% |
| s | 100021 | 4.4% |
| ste | 63642 | 2.8% |
| 101 | 53433 | 2.3% |
| main | 48136 | 2.1% |
| philips | 46635 | 2.0% |
| pkwy | 39720 | 1.7% |
| high | 39129 | 1.7% |
| Other values (3179) | 1431577 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1689937 | ||
| 1 | 632448 | 6.4% |
| t | 578993 | 5.8% |
| S | 482726 | 4.9% |
| e | 474284 | 4.8% |
| i | 423755 | 4.3% |
| 0 | 423374 | 4.3% |
| a | 371394 | 3.7% |
| n | 330798 | 3.3% |
| l | 310763 | 3.1% |
| Other values (64) | 4193221 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4378249 | |
| Decimal Number | 2109100 | |
| Space Separator | 1689937 | 17.0% |
| Uppercase Letter | 1598294 | 16.1% |
| Other Punctuation | 121141 | 1.2% |
| Math Symbol | 9305 | 0.1% |
| Dash Punctuation | 5665 | 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 578993 | |
| e | 474284 | |
| i | 423755 | |
| a | 371394 | 8.5% |
| n | 330798 | 7.6% |
| l | 310763 | 7.1% |
| r | 279740 | 6.4% |
| s | 219466 | 5.0% |
| o | 219408 | 5.0% |
| h | 206675 | 4.7% |
| Other values (16) | 962973 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 482726 | |
| P | 175100 | 11.0% |
| A | 130875 | 8.2% |
| N | 118165 | 7.4% |
| M | 96061 | 6.0% |
| W | 88439 | 5.5% |
| H | 65913 | 4.1% |
| R | 58065 | 3.6% |
| B | 53426 | 3.3% |
| F | 50951 | 3.2% |
| Other values (16) | 278573 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 632448 | |
| 0 | 423374 | |
| 2 | 234938 | 11.1% |
| 5 | 192540 | 9.1% |
| 7 | 136417 | 6.5% |
| 4 | 135467 | 6.4% |
| 3 | 130178 | 6.2% |
| 9 | 80696 | 3.8% |
| 8 | 74890 | 3.6% |
| 6 | 68152 | 3.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 92959 | |
| & | 15015 | 12.4% |
| . | 11459 | 9.5% |
| ' | 953 | 0.8% |
| # | 547 | 0.5% |
| / | 208 | 0.2% |
Math Symbol
| Value | Count | Frequency (%) |
| < | 4653 | |
| > | 4652 |
Space Separator
| Value | Count | Frequency (%) |
| 1689937 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5665 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5976543 | |
| Common | 3935150 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 578993 | 9.7% |
| S | 482726 | 8.1% |
| e | 474284 | 7.9% |
| i | 423755 | 7.1% |
| a | 371394 | 6.2% |
| n | 330798 | 5.5% |
| l | 310763 | 5.2% |
| r | 279740 | 4.7% |
| s | 219466 | 3.7% |
| o | 219408 | 3.7% |
| Other values (42) | 2285216 |
Common
| Value | Count | Frequency (%) |
| 1689937 | ||
| 1 | 632448 | 16.1% |
| 0 | 423374 | 10.8% |
| 2 | 234938 | 6.0% |
| 5 | 192540 | 4.9% |
| 7 | 136417 | 3.5% |
| 4 | 135467 | 3.4% |
| 3 | 130178 | 3.3% |
| , | 92959 | 2.4% |
| 9 | 80696 | 2.1% |
| Other values (12) | 186196 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9911693 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1689937 | ||
| 1 | 632448 | 6.4% |
| t | 578993 | 5.8% |
| S | 482726 | 4.9% |
| e | 474284 | 4.8% |
| i | 423755 | 4.3% |
| 0 | 423374 | 4.3% |
| a | 371394 | 3.7% |
| n | 330798 | 3.3% |
| l | 310763 | 3.1% |
| Other values (64) | 4193221 |
BankCity
Categorical
| Distinct | 2184 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| COLUMBUS | |
|---|---|
| SIOUX FALLS | |
| WILMINGTON | 34735 |
| CINCINNATI | 32285 |
| SALT LAKE CITY | 16659 |
| Other values (2179) |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 9.4283691 |
| Min length | 3 |
Characters and Unicode
| Total characters | 5544343 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 250 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SALT LAKE CITY |
|---|---|
| 2nd row | QUINCY |
| 3rd row | SIOUX FALLS |
| 4th row | DANBURY |
| 5th row | Rancho Cucamonga |
Common Values
| Value | Count | Frequency (%) |
| COLUMBUS | 76399 | 13.0% |
| SIOUX FALLS | 50551 | 8.6% |
| WILMINGTON | 34735 | 5.9% |
| CINCINNATI | 32285 | 5.5% |
| SALT LAKE CITY | 16659 | 2.8% |
| LOS ANGELES | 16486 | 2.8% |
| BIRMINGHAM | 14120 | 2.4% |
| BUFFALO | 13967 | 2.4% |
| CHARLOTTE | 10841 | 1.8% |
| CLEVELAND | 7874 | 1.3% |
| Other values (2174) | 314132 |
Length
| Value | Count | Frequency (%) |
| columbus | 76504 | 9.5% |
| falls | 51276 | 6.4% |
| sioux | 50606 | 6.3% |
| wilmington | 34801 | 4.3% |
| cincinnati | 32285 | 4.0% |
| city | 28343 | 3.5% |
| lake | 22569 | 2.8% |
| salt | 16709 | 2.1% |
| los | 16693 | 2.1% |
| angeles | 16693 | 2.1% |
| Other values (2008) | 458012 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 517427 | 9.3% |
| A | 440024 | 7.9% |
| I | 437492 | 7.9% |
| N | 407047 | 7.3% |
| O | 402274 | 7.3% |
| S | 399668 | 7.2% |
| E | 322974 | 5.8% |
| C | 292276 | 5.3% |
| U | 285975 | 5.2% |
| T | 261815 | 4.7% |
| Other values (43) | 1777371 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5110099 | |
| Lowercase Letter | 217670 | 3.9% |
| Space Separator | 216442 | 3.9% |
| Other Punctuation | 132 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 517427 | 10.1% |
| A | 440024 | 8.6% |
| I | 437492 | 8.6% |
| N | 407047 | 8.0% |
| O | 402274 | 7.9% |
| S | 399668 | 7.8% |
| E | 322974 | 6.3% |
| C | 292276 | 5.7% |
| U | 285975 | 5.6% |
| T | 261815 | 5.1% |
| Other values (16) | 1343127 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 31836 | |
| n | 25219 | |
| o | 19412 | |
| e | 17907 | 8.2% |
| r | 14489 | 6.7% |
| u | 13607 | 6.3% |
| g | 13011 | 6.0% |
| c | 12906 | 5.9% |
| t | 12635 | 5.8% |
| i | 10345 | 4.8% |
| Other values (14) | 46303 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 81 | |
| . | 51 |
Space Separator
| Value | Count | Frequency (%) |
| 216442 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5327769 | |
| Common | 216574 | 3.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 517427 | 9.7% |
| A | 440024 | 8.3% |
| I | 437492 | 8.2% |
| N | 407047 | 7.6% |
| O | 402274 | 7.6% |
| S | 399668 | 7.5% |
| E | 322974 | 6.1% |
| C | 292276 | 5.5% |
| U | 285975 | 5.4% |
| T | 261815 | 4.9% |
| Other values (40) | 1560797 |
Common
| Value | Count | Frequency (%) |
| 216442 | ||
| ' | 81 | < 0.1% |
| . | 51 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5544343 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 517427 | 9.3% |
| A | 440024 | 7.9% |
| I | 437492 | 7.9% |
| N | 407047 | 7.3% |
| O | 402274 | 7.3% |
| S | 399668 | 7.2% |
| E | 322974 | 5.8% |
| C | 292276 | 5.3% |
| U | 285975 | 5.2% |
| T | 261815 | 4.7% |
| Other values (43) | 1777371 |
BankState
Categorical
HIGH CARDINALITY  HIGH CORRELATION 
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| OH | |
|---|---|
| CA | |
| SD | |
| NY | 29944 |
| DE | 26274 |
| Other values (50) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1176098 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | UT |
|---|---|
| 2nd row | CA |
| 3rd row | SD |
| 4th row | CT |
| 5th row | CA |
Common Values
| Value | Count | Frequency (%) |
| OH | 121906 | |
| CA | 52910 | 9.0% |
| SD | 51478 | 8.8% |
| NY | 29944 | 5.1% |
| DE | 26274 | 4.5% |
| NC | 23601 | 4.0% |
| UT | 21333 | 3.6% |
| MA | 20427 | 3.5% |
| TX | 18702 | 3.2% |
| MN | 14961 | 2.5% |
| Other values (45) | 206513 |
Length
| Value | Count | Frequency (%) |
| oh | 121906 | |
| ca | 52910 | 9.0% |
| sd | 51478 | 8.8% |
| ny | 29944 | 5.1% |
| de | 26274 | 4.5% |
| nc | 23601 | 4.0% |
| ut | 21333 | 3.6% |
| ma | 20427 | 3.5% |
| tx | 18702 | 3.2% |
| mn | 14961 | 2.5% |
| Other values (45) | 206513 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 142276 | |
| O | 140820 | |
| H | 127063 | |
| N | 96635 | 8.2% |
| C | 84415 | 7.2% |
| D | 82931 | 7.1% |
| M | 63925 | 5.4% |
| S | 60839 | 5.2% |
| I | 56898 | 4.8% |
| T | 54877 | 4.7% |
| Other values (15) | 265419 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1176097 | |
| Lowercase Letter | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 142276 | |
| O | 140820 | |
| H | 127063 | |
| N | 96635 | 8.2% |
| C | 84415 | 7.2% |
| D | 82931 | 7.1% |
| M | 63925 | 5.4% |
| S | 60839 | 5.2% |
| I | 56898 | 4.8% |
| T | 54877 | 4.7% |
| Other values (14) | 265418 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1176098 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 142276 | |
| O | 140820 | |
| H | 127063 | |
| N | 96635 | 8.2% |
| C | 84415 | 7.2% |
| D | 82931 | 7.1% |
| M | 63925 | 5.4% |
| S | 60839 | 5.2% |
| I | 56898 | 4.8% |
| T | 54877 | 4.7% |
| Other values (15) | 265419 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1176098 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 142276 | |
| O | 140820 | |
| H | 127063 | |
| N | 96635 | 8.2% |
| C | 84415 | 7.2% |
| D | 82931 | 7.1% |
| M | 63925 | 5.4% |
| S | 60839 | 5.2% |
| I | 56898 | 4.8% |
| T | 54877 | 4.7% |
| Other values (15) | 265419 |
BankZip
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 4 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
GrossApproval
Real number (ℝ)
| Distinct | 22149 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 393387.47 |
| Minimum | 1000 |
|---|---|
| Maximum | 5000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 45000 |
| median | 137500 |
| Q3 | 381000 |
| 95-th percentile | 1762500 |
| Maximum | 5000000 |
| Range | 4999000 |
| Interquartile range (IQR) | 336000 |
Descriptive statistics
| Standard deviation | 695480.22 |
|---|---|
| Coefficient of variation (CV) | 1.7679267 |
| Kurtosis | 14.87773 |
| Mean | 393387.47 |
| Median Absolute Deviation (MAD) | 112500 |
| Skewness | 3.5098264 |
| Sum | 2.3133268 × 1011 |
| Variance | 4.8369274 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50000 | 38301 | 6.5% |
| 25000 | 34004 | 5.8% |
| 100000 | 29006 | 4.9% |
| 150000 | 28342 | 4.8% |
| 10000 | 20256 | 3.4% |
| 350000 | 15196 | 2.6% |
| 20000 | 14203 | 2.4% |
| 15000 | 12876 | 2.2% |
| 250000 | 11020 | 1.9% |
| 30000 | 10421 | 1.8% |
| Other values (22139) | 374428 |
| Value | Count | Frequency (%) |
| 1000 | 19 | |
| 1500 | 4 | < 0.1% |
| 1600 | 1 | < 0.1% |
| 1700 | 1 | < 0.1% |
| 1900 | 1 | < 0.1% |
| 2000 | 12 | |
| 2300 | 2 | < 0.1% |
| 2400 | 2 | < 0.1% |
| 2500 | 17 | |
| 2600 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5000000 | 1898 | |
| 4999900 | 3 | < 0.1% |
| 4999700 | 1 | < 0.1% |
| 4999500 | 1 | < 0.1% |
| 4999000 | 1 | < 0.1% |
| 4998600 | 1 | < 0.1% |
| 4998200 | 1 | < 0.1% |
| 4998100 | 1 | < 0.1% |
| 4998000 | 4 | < 0.1% |
| 4997000 | 1 | < 0.1% |
SBAGuaranteedApproval
Real number (ℝ)
| Distinct | 29376 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291622.72 |
| Minimum | 500 |
|---|---|
| Maximum | 6175000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 5000 |
| Q1 | 25000 |
| median | 87500 |
| Q3 | 288750 |
| 95-th percentile | 1350000 |
| Maximum | 6175000 |
| Range | 6174500 |
| Interquartile range (IQR) | 263750 |
Descriptive statistics
| Standard deviation | 534271.76 |
|---|---|
| Coefficient of variation (CV) | 1.832065 |
| Kurtosis | 15.186445 |
| Mean | 291622.72 |
| Median Absolute Deviation (MAD) | 75000 |
| Skewness | 3.5212083 |
| Sum | 1.7148961 × 1011 |
| Variance | 2.8544631 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25000 | 33927 | 5.8% |
| 12500 | 30767 | 5.2% |
| 50000 | 22195 | 3.8% |
| 5000 | 18816 | 3.2% |
| 127500 | 17082 | 2.9% |
| 10000 | 13100 | 2.2% |
| 7500 | 11719 | 2.0% |
| 75000 | 10628 | 1.8% |
| 15000 | 9580 | 1.6% |
| 2500 | 8383 | 1.4% |
| Other values (29366) | 411856 |
| Value | Count | Frequency (%) |
| 500 | 19 | |
| 750 | 4 | < 0.1% |
| 800 | 1 | < 0.1% |
| 850 | 1 | < 0.1% |
| 950 | 1 | < 0.1% |
| 1000 | 12 | |
| 1150 | 2 | < 0.1% |
| 1200 | 2 | < 0.1% |
| 1250 | 16 | |
| 1300 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 6175000 | 1 | < 0.1% |
| 5400000 | 1 | < 0.1% |
| 5250000 | 1 | < 0.1% |
| 5124526 | 1 | < 0.1% |
| 4556600 | 1 | < 0.1% |
| 4500000 | 276 | |
| 4498740 | 1 | < 0.1% |
| 4493718 | 1 | < 0.1% |
| 4492530 | 1 | < 0.1% |
| 4490370 | 1 | < 0.1% |
ApprovalDate
Categorical
| Distinct | 3761 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 11-03-2010 | 1500 |
|---|---|
| 28-07-2015 | 1358 |
| 01-10-2010 | 1082 |
| 24-12-2009 | 1001 |
| 28-01-2019 | 976 |
| Other values (3756) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 5880530 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 197 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 01-10-2009 |
|---|---|
| 2nd row | 01-10-2009 |
| 3rd row | 01-10-2009 |
| 4th row | 01-10-2009 |
| 5th row | 01-10-2009 |
Common Values
| Value | Count | Frequency (%) |
| 11-03-2010 | 1500 | 0.3% |
| 28-07-2015 | 1358 | 0.2% |
| 01-10-2010 | 1082 | 0.2% |
| 24-12-2009 | 1001 | 0.2% |
| 28-01-2019 | 976 | 0.2% |
| 22-07-2015 | 955 | 0.2% |
| 30-09-2013 | 912 | 0.2% |
| 20-11-2009 | 902 | 0.2% |
| 21-07-2015 | 880 | 0.1% |
| 23-07-2015 | 815 | 0.1% |
| Other values (3751) | 577672 |
Length
| Value | Count | Frequency (%) |
| 11-03-2010 | 1500 | 0.3% |
| 28-07-2015 | 1358 | 0.2% |
| 01-10-2010 | 1082 | 0.2% |
| 24-12-2009 | 1001 | 0.2% |
| 28-01-2019 | 976 | 0.2% |
| 22-07-2015 | 955 | 0.2% |
| 30-09-2013 | 912 | 0.2% |
| 20-11-2009 | 902 | 0.2% |
| 21-07-2015 | 880 | 0.1% |
| 23-07-2015 | 815 | 0.1% |
| Other values (3751) | 577672 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1386831 | |
| - | 1176106 | |
| 1 | 1081879 | |
| 2 | 1027143 | |
| 3 | 185939 | 3.2% |
| 9 | 178953 | 3.0% |
| 7 | 172461 | 2.9% |
| 6 | 170441 | 2.9% |
| 5 | 169680 | 2.9% |
| 8 | 167492 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4704424 | |
| Dash Punctuation | 1176106 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1386831 | |
| 1 | 1081879 | |
| 2 | 1027143 | |
| 3 | 185939 | 4.0% |
| 9 | 178953 | 3.8% |
| 7 | 172461 | 3.7% |
| 6 | 170441 | 3.6% |
| 5 | 169680 | 3.6% |
| 8 | 167492 | 3.6% |
| 4 | 163605 | 3.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1176106 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5880530 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1386831 | |
| - | 1176106 | |
| 1 | 1081879 | |
| 2 | 1027143 | |
| 3 | 185939 | 3.2% |
| 9 | 178953 | 3.0% |
| 7 | 172461 | 2.9% |
| 6 | 170441 | 2.9% |
| 5 | 169680 | 2.9% |
| 8 | 167492 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5880530 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1386831 | |
| - | 1176106 | |
| 1 | 1081879 | |
| 2 | 1027143 | |
| 3 | 185939 | 3.2% |
| 9 | 178953 | 3.0% |
| 7 | 172461 | 2.9% |
| 6 | 170441 | 2.9% |
| 5 | 169680 | 2.9% |
| 8 | 167492 | 2.8% |
ApprovalFiscalYear
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.1043 |
| Minimum | 2010 |
|---|---|
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2010 |
| Q1 | 2013 |
| median | 2015 |
| Q3 | 2018 |
| 95-th percentile | 2020 |
| Maximum | 2020 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.0331319 |
|---|---|
| Coefficient of variation (CV) | 0.0015051985 |
| Kurtosis | -1.1194012 |
| Mean | 2015.1043 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.11117726 |
| Sum | 1.1849881 × 109 |
| Variance | 9.1998893 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 2016 | 64074 | |
| 2015 | 63461 | |
| 2017 | 62430 | |
| 2018 | 60354 | |
| 2011 | 53710 | |
| 2014 | 52044 | |
| 2019 | 51907 | |
| 2010 | 47000 | |
| 2013 | 46395 | |
| 2012 | 44376 |
| Value | Count | Frequency (%) |
| 2010 | 47000 | |
| 2011 | 53710 | |
| 2012 | 44376 | |
| 2013 | 46395 | |
| 2014 | 52044 | |
| 2015 | 63461 | |
| 2016 | 64074 | |
| 2017 | 62430 | |
| 2018 | 60354 | |
| 2019 | 51907 |
| Value | Count | Frequency (%) |
| 2020 | 42302 | |
| 2019 | 51907 | |
| 2018 | 60354 | |
| 2017 | 62430 | |
| 2016 | 64074 | |
| 2015 | 63461 | |
| 2014 | 52044 | |
| 2013 | 46395 | |
| 2012 | 44376 | |
| 2011 | 53710 |
FirstDisbursementDate
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 3530 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 82091 |
| Missing (%) | 14.0% |
| Memory size | 4.5 MiB |
| 30-06-2017 | 5104 |
|---|---|
| 31-10-2017 | 4985 |
| 30-09-2017 | 4928 |
| 31-08-2017 | 4914 |
| 31-05-2017 | 4882 |
| Other values (3525) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 5059620 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 325 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 01-10-2009 |
|---|---|
| 2nd row | 01-10-2009 |
| 3rd row | 01-11-2009 |
| 4th row | 01-10-2009 |
| 5th row | 01-10-2009 |
Common Values
| Value | Count | Frequency (%) |
| 30-06-2017 | 5104 | 0.9% |
| 31-10-2017 | 4985 | 0.8% |
| 30-09-2017 | 4928 | 0.8% |
| 31-08-2017 | 4914 | 0.8% |
| 31-05-2017 | 4882 | 0.8% |
| 31-03-2018 | 4715 | 0.8% |
| 31-05-2018 | 4622 | 0.8% |
| 31-12-2017 | 4547 | 0.8% |
| 30-06-2018 | 4529 | 0.8% |
| 31-08-2018 | 4504 | 0.8% |
| Other values (3520) | 458232 | |
| (Missing) | 82091 | 14.0% |
Length
| Value | Count | Frequency (%) |
| 30-06-2017 | 5104 | 1.0% |
| 31-10-2017 | 4985 | 1.0% |
| 30-09-2017 | 4928 | 1.0% |
| 31-08-2017 | 4914 | 1.0% |
| 31-05-2017 | 4882 | 1.0% |
| 31-03-2018 | 4715 | 0.9% |
| 31-05-2018 | 4622 | 0.9% |
| 31-12-2017 | 4547 | 0.9% |
| 30-06-2018 | 4529 | 0.9% |
| 31-08-2018 | 4504 | 0.9% |
| Other values (3520) | 458232 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1323670 | |
| 1 | 1088211 | |
| - | 1011924 | |
| 2 | 709020 | |
| 3 | 250031 | 4.9% |
| 8 | 118551 | 2.3% |
| 6 | 116900 | 2.3% |
| 7 | 113866 | 2.3% |
| 5 | 112864 | 2.2% |
| 9 | 108870 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4047696 | |
| Dash Punctuation | 1011924 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1323670 | |
| 1 | 1088211 | |
| 2 | 709020 | |
| 3 | 250031 | 6.2% |
| 8 | 118551 | 2.9% |
| 6 | 116900 | 2.9% |
| 7 | 113866 | 2.8% |
| 5 | 112864 | 2.8% |
| 9 | 108870 | 2.7% |
| 4 | 105713 | 2.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1011924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5059620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1323670 | |
| 1 | 1088211 | |
| - | 1011924 | |
| 2 | 709020 | |
| 3 | 250031 | 4.9% |
| 8 | 118551 | 2.3% |
| 6 | 116900 | 2.3% |
| 7 | 113866 | 2.3% |
| 5 | 112864 | 2.2% |
| 9 | 108870 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5059620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1323670 | |
| 1 | 1088211 | |
| - | 1011924 | |
| 2 | 709020 | |
| 3 | 250031 | 4.9% |
| 8 | 118551 | 2.3% |
| 6 | 116900 | 2.3% |
| 7 | 113866 | 2.3% |
| 5 | 112864 | 2.2% |
| 9 | 108870 | 2.2% |
DeliveryMethod
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| SBA EXPRES | |
|---|---|
| PLP | |
| OTH 7A | |
| SLA | |
| CA | 6390 |
| Other values (10) | 24272 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 6.780814 |
| Min length | 2 |
Characters and Unicode
| Total characters | 3987478 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SBA EXPRES |
|---|---|
| 2nd row | PLP |
| 3rd row | PLP |
| 4th row | SBA EXPRES |
| 5th row | COMM EXPRS |
Common Values
| Value | Count | Frequency (%) |
| SBA EXPRES | 280906 | |
| PLP | 195338 | |
| OTH 7A | 49625 | 8.4% |
| SLA | 31522 | 5.4% |
| CA | 6390 | 1.1% |
| PATRIOT EX | 6247 | 1.1% |
| COMM EXPRS | 5468 | 0.9% |
| RLA | 3096 | 0.5% |
| CLP | 2653 | 0.5% |
| EWCP | 1798 | 0.3% |
| Other values (5) | 5010 | 0.9% |
Length
| Value | Count | Frequency (%) |
| expres | 282362 | |
| sba | 280906 | |
| plp | 195338 | |
| oth | 49625 | 5.3% |
| 7a | 49625 | 5.3% |
| sla | 31522 | 3.4% |
| ca | 6390 | 0.7% |
| patriot | 6247 | 0.7% |
| ex | 6247 | 0.7% |
| exprs | 5468 | 0.6% |
| Other values (11) | 21443 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 690785 | |
| S | 601978 | |
| E | 583100 | |
| A | 379506 | |
| 347120 | ||
| R | 300569 | |
| X | 295544 | |
| B | 280906 | |
| L | 234329 | 5.9% |
| T | 65515 | 1.6% |
| Other values (11) | 208126 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3590733 | |
| Space Separator | 347120 | 8.7% |
| Decimal Number | 49625 | 1.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 690785 | |
| S | 601978 | |
| E | 583100 | |
| A | 379506 | |
| R | 300569 | |
| X | 295544 | |
| B | 280906 | |
| L | 234329 | 6.5% |
| T | 65515 | 1.8% |
| O | 64780 | 1.8% |
| Other values (9) | 93721 | 2.6% |
Space Separator
| Value | Count | Frequency (%) |
| 347120 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 49625 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3590733 | |
| Common | 396745 | 9.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 690785 | |
| S | 601978 | |
| E | 583100 | |
| A | 379506 | |
| R | 300569 | |
| X | 295544 | |
| B | 280906 | |
| L | 234329 | 6.5% |
| T | 65515 | 1.8% |
| O | 64780 | 1.8% |
| Other values (9) | 93721 | 2.6% |
Common
| Value | Count | Frequency (%) |
| 347120 | ||
| 7 | 49625 | 12.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3987478 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 690785 | |
| S | 601978 | |
| E | 583100 | |
| A | 379506 | |
| 347120 | ||
| R | 300569 | |
| X | 295544 | |
| B | 280906 | |
| L | 234329 | 5.9% |
| T | 65515 | 1.6% |
| Other values (11) | 208126 | 5.2% |
subpgmdesc
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| FA$TRK (Small Loan Express) | |
|---|---|
| Guaranty | |
| Lender Advantage Initiative | |
| Community Advantage Initiative | 6457 |
| Patriot Express | 6247 |
| Other values (12) | 18370 |
Length
| Max length | 49 |
|---|---|
| Median length | 27 |
| Mean length | 18.942708 |
| Min length | 8 |
Characters and Unicode
| Total characters | 11139316 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FA$TRK (Small Loan Express) |
|---|---|
| 2nd row | Guaranty |
| 3rd row | Guaranty |
| 4th row | FA$TRK (Small Loan Express) |
| 5th row | Community Express |
Common Values
| Value | Count | Frequency (%) |
| FA$TRK (Small Loan Express) | 282368 | |
| Guaranty | 243090 | |
| Lender Advantage Initiative | 31521 | 5.4% |
| Community Advantage Initiative | 6457 | 1.1% |
| Patriot Express | 6247 | 1.1% |
| Community Express | 5468 | 0.9% |
| Standard Asset Based | 3394 | 0.6% |
| Rural Lender Advantage | 3096 | 0.5% |
| Revolving Line of Credit Exports - Sec. 7(a) (14) | 1800 | 0.3% |
| Gulf Opportunity | 1720 | 0.3% |
| Other values (7) | 2892 | 0.5% |
Length
| Value | Count | Frequency (%) |
| express | 294083 | |
| small | 282571 | |
| fa$trk | 282368 | |
| loan | 282368 | |
| guaranty | 243703 | |
| advantage | 41074 | 2.6% |
| initiative | 37978 | 2.4% |
| lender | 34617 | 2.2% |
| community | 11925 | 0.8% |
| patriot | 6247 | 0.4% |
| Other values (30) | 46379 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1202206 | 10.8% |
| 975260 | 8.8% | |
| n | 666884 | 6.0% |
| s | 600685 | 5.4% |
| r | 595180 | 5.3% |
| l | 573853 | 5.2% |
| e | 462738 | 4.2% |
| t | 404206 | 3.6% |
| A | 327156 | 2.9% |
| L | 319398 | 2.9% |
| Other values (43) | 5011750 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6602426 | |
| Uppercase Letter | 2681268 | |
| Space Separator | 975260 | 8.8% |
| Open Punctuation | 289682 | 2.6% |
| Close Punctuation | 289682 | 2.6% |
| Currency Symbol | 282368 | 2.5% |
| Decimal Number | 11191 | 0.1% |
| Dash Punctuation | 3782 | < 0.1% |
| Other Punctuation | 3657 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 327156 | |
| L | 319398 | |
| E | 296144 | |
| S | 289860 | |
| R | 287547 | |
| T | 284103 | |
| F | 282493 | |
| K | 282368 | |
| G | 245578 | |
| I | 39713 | 1.5% |
| Other values (10) | 26908 | 1.0% |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1202206 | |
| n | 666884 | |
| s | 600685 | |
| r | 595180 | |
| l | 573853 | |
| e | 462738 | 7.0% |
| t | 404206 | 6.1% |
| o | 310761 | 4.7% |
| m | 306421 | 4.6% |
| p | 299323 | 4.5% |
| Other values (9) | 1180169 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 3657 | |
| 1 | 3502 | |
| 4 | 1800 | |
| 6 | 1702 | |
| 9 | 280 | 2.5% |
| 5 | 125 | 1.1% |
| 0 | 125 | 1.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1955 | |
| , | 1702 |
Space Separator
| Value | Count | Frequency (%) |
| 975260 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 289682 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 289682 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 282368 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3782 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9283694 | |
| Common | 1855622 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1202206 | 12.9% |
| n | 666884 | 7.2% |
| s | 600685 | 6.5% |
| r | 595180 | 6.4% |
| l | 573853 | 6.2% |
| e | 462738 | 5.0% |
| t | 404206 | 4.4% |
| A | 327156 | 3.5% |
| L | 319398 | 3.4% |
| o | 310761 | 3.3% |
| Other values (29) | 3820627 |
Common
| Value | Count | Frequency (%) |
| 975260 | ||
| ( | 289682 | 15.6% |
| ) | 289682 | 15.6% |
| $ | 282368 | 15.2% |
| - | 3782 | 0.2% |
| 7 | 3657 | 0.2% |
| 1 | 3502 | 0.2% |
| . | 1955 | 0.1% |
| 4 | 1800 | 0.1% |
| , | 1702 | 0.1% |
| Other values (4) | 2232 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11139316 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1202206 | 10.8% |
| 975260 | 8.8% | |
| n | 666884 | 6.0% |
| s | 600685 | 5.4% |
| r | 595180 | 5.3% |
| l | 573853 | 5.2% |
| e | 462738 | 4.2% |
| t | 404206 | 3.6% |
| A | 327156 | 2.9% |
| L | 319398 | 2.9% |
| Other values (43) | 5011750 |
InitialInterestRate
Real number (ℝ)
| Distinct | 1869 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5260795 |
| Minimum | 0 |
|---|---|
| Maximum | 13.5 |
| Zeros | 21 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.5 |
| Q1 | 5.5 |
| median | 6 |
| Q3 | 7.5 |
| 95-th percentile | 9.75 |
| Maximum | 13.5 |
| Range | 13.5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5680676 |
|---|---|
| Coefficient of variation (CV) | 0.24027712 |
| Kurtosis | 0.80181718 |
| Mean | 6.5260795 |
| Median Absolute Deviation (MAD) | 0.75 |
| Skewness | 0.83206164 |
| Sum | 3837674.1 |
| Variance | 2.458836 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 88470 | 15.0% |
| 5.5 | 38324 | 6.5% |
| 5.25 | 35171 | 6.0% |
| 5.75 | 31785 | 5.4% |
| 6.25 | 28211 | 4.8% |
| 7 | 22706 | 3.9% |
| 6.5 | 21248 | 3.6% |
| 7.75 | 19919 | 3.4% |
| 5 | 19804 | 3.4% |
| 7.5 | 17968 | 3.1% |
| Other values (1859) | 264446 |
| Value | Count | Frequency (%) |
| 0 | 21 | < 0.1% |
| 0.5 | 3 | < 0.1% |
| 0.66 | 1 | < 0.1% |
| 0.75 | 7 | < 0.1% |
| 0.85 | 1 | < 0.1% |
| 1 | 71 | |
| 1.01 | 1 | < 0.1% |
| 1.16 | 1 | < 0.1% |
| 1.2 | 1 | < 0.1% |
| 1.24 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.5 | 2 | < 0.1% |
| 13.25 | 3 | < 0.1% |
| 12.99 | 12 | |
| 12.75 | 3 | < 0.1% |
| 12.74 | 2 | < 0.1% |
| 12.5 | 3 | < 0.1% |
| 12.493 | 1 | < 0.1% |
| 12.49 | 4 | < 0.1% |
| 12.25 | 2 | < 0.1% |
| 12.24 | 4 | < 0.1% |
TermInMonths
Real number (ℝ)
| Distinct | 335 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 123.53789 |
| Minimum | 0 |
|---|---|
| Maximum | 847 |
| Zeros | 109 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 84 |
| median | 91 |
| Q3 | 120 |
| 95-th percentile | 300 |
| Maximum | 847 |
| Range | 847 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 79.111359 |
|---|---|
| Coefficient of variation (CV) | 0.64038136 |
| Kurtosis | 0.69057441 |
| Mean | 123.53789 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | 1.3370841 |
| Sum | 72646824 |
| Variance | 6258.6071 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 84 | 158893 | |
| 120 | 150221 | |
| 300 | 65482 | |
| 60 | 59789 | 10.2% |
| 240 | 12754 | 2.2% |
| 180 | 8711 | 1.5% |
| 36 | 8429 | 1.4% |
| 12 | 6489 | 1.1% |
| 48 | 6405 | 1.1% |
| 72 | 5965 | 1.0% |
| Other values (325) | 104915 |
| Value | Count | Frequency (%) |
| 0 | 109 | < 0.1% |
| 1 | 182 | < 0.1% |
| 2 | 251 | |
| 3 | 324 | |
| 4 | 304 | |
| 5 | 269 | |
| 6 | 544 | |
| 7 | 277 | |
| 8 | 248 | |
| 9 | 260 |
| Value | Count | Frequency (%) |
| 847 | 1 | < 0.1% |
| 720 | 2 | |
| 400 | 1 | < 0.1% |
| 360 | 4 | |
| 352 | 1 | < 0.1% |
| 345 | 1 | < 0.1% |
| 343 | 1 | < 0.1% |
| 332 | 1 | < 0.1% |
| 328 | 2 | |
| 326 | 2 |
NaicsCode
Real number (ℝ)
| Distinct | 1256 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 12 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 523739.05 |
| Minimum | 111110 |
|---|---|
| Maximum | 928120 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 111110 |
|---|---|
| 5-th percentile | 237310 |
| Q1 | 424930 |
| median | 541110 |
| Q3 | 624410 |
| 95-th percentile | 812111 |
| Maximum | 928120 |
| Range | 817010 |
| Interquartile range (IQR) | 199480 |
Descriptive statistics
| Standard deviation | 175451.23 |
|---|---|
| Coefficient of variation (CV) | 0.33499742 |
| Kurtosis | -0.69789387 |
| Mean | 523739.05 |
| Median Absolute Deviation (MAD) | 116120 |
| Skewness | -0.17036997 |
| Sum | 3.0798004 × 1011 |
| Variance | 3.0783134 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 722511 | 22534 | 3.8% |
| 722513 | 14979 | 2.5% |
| 621210 | 11244 | 1.9% |
| 484121 | 9798 | 1.7% |
| 721110 | 9453 | 1.6% |
| 713940 | 9149 | 1.6% |
| 621111 | 8618 | 1.5% |
| 561730 | 8461 | 1.4% |
| 811111 | 8363 | 1.4% |
| 238990 | 8341 | 1.4% |
| Other values (1246) | 477101 |
| Value | Count | Frequency (%) |
| 111110 | 81 | |
| 111120 | 5 | < 0.1% |
| 111130 | 1 | < 0.1% |
| 111140 | 17 | < 0.1% |
| 111150 | 51 | |
| 111160 | 1 | < 0.1% |
| 111191 | 19 | < 0.1% |
| 111199 | 45 | |
| 111211 | 23 | < 0.1% |
| 111219 | 103 |
| Value | Count | Frequency (%) |
| 928120 | 2 | < 0.1% |
| 926150 | 9 | |
| 926140 | 1 | < 0.1% |
| 926130 | 3 | < 0.1% |
| 926120 | 2 | < 0.1% |
| 926110 | 3 | < 0.1% |
| 925120 | 1 | < 0.1% |
| 924120 | 1 | < 0.1% |
| 924110 | 11 | |
| 923130 | 7 |
NaicsDescription
Categorical
| Distinct | 1220 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 742 |
| Missing (%) | 0.1% |
| Memory size | 4.5 MiB |
| Full-Service Restaurants | 30672 |
|---|---|
| Limited-Service Restaurants | 20473 |
| Offices of Dentists | 11244 |
| General Freight Trucking, Long Distance, Truckload | 9798 |
| Hotels (except Casino Hotels) and Motels | 9453 |
| Other values (1215) |
Length
| Max length | 70 |
|---|---|
| Median length | 57 |
| Mean length | 34.014634 |
| Min length | 7 |
Characters and Unicode
| Total characters | 19977169 |
|---|---|
| Distinct characters | 59 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 51 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Offices of Real Estate Agents and Brokers |
|---|---|
| 2nd row | Drinking Places (Alcoholic Beverages) |
| 3rd row | Car Washes |
| 4th row | Commercial Lithographic Printing |
| 5th row | Automotive Body, Paint, and Interior Repair and Maintenance |
Common Values
| Value | Count | Frequency (%) |
| Full-Service Restaurants | 30672 | 5.2% |
| Limited-Service Restaurants | 20473 | 3.5% |
| Offices of Dentists | 11244 | 1.9% |
| General Freight Trucking, Long Distance, Truckload | 9798 | 1.7% |
| Hotels (except Casino Hotels) and Motels | 9453 | 1.6% |
| Fitness and Recreational Sports Centers | 9149 | 1.6% |
| Offices of Physicians (except Mental Health Specialists) | 8618 | 1.5% |
| Landscaping Services | 8461 | 1.4% |
| General Automotive Repair | 8363 | 1.4% |
| All Other Specialty Trade Contractors | 8341 | 1.4% |
| Other values (1210) | 462739 |
Length
| Value | Count | Frequency (%) |
| and | 213787 | 8.7% |
| other | 101785 | 4.1% |
| services | 97409 | 4.0% |
| stores | 63473 | 2.6% |
| of | 55282 | 2.2% |
| restaurants | 51145 | 2.1% |
| offices | 49218 | 2.0% |
| except | 48580 | 2.0% |
| all | 46729 | 1.9% |
| contractors | 44293 | 1.8% |
| Other values (1488) | 1693893 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2120751 | 10.6% |
| 1878283 | 9.4% | |
| r | 1379836 | 6.9% |
| a | 1323156 | 6.6% |
| t | 1321203 | 6.6% |
| n | 1310268 | 6.6% |
| i | 1308803 | 6.6% |
| s | 1140870 | 5.7% |
| o | 1013258 | 5.1% |
| c | 833558 | 4.2% |
| Other values (49) | 6347183 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15581319 | |
| Uppercase Letter | 2198173 | 11.0% |
| Space Separator | 1878283 | 9.4% |
| Other Punctuation | 136706 | 0.7% |
| Dash Punctuation | 73925 | 0.4% |
| Open Punctuation | 55555 | 0.3% |
| Close Punctuation | 53208 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2120751 | |
| r | 1379836 | |
| a | 1323156 | |
| t | 1321203 | |
| n | 1310268 | |
| i | 1308803 | |
| s | 1140870 | 7.3% |
| o | 1013258 | 6.5% |
| c | 833558 | 5.3% |
| l | 820516 | 5.3% |
| Other values (16) | 3009100 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 378889 | |
| C | 238286 | |
| O | 176894 | 8.0% |
| M | 174836 | 8.0% |
| A | 142700 | 6.5% |
| R | 137357 | 6.2% |
| P | 134828 | 6.1% |
| F | 110242 | 5.0% |
| L | 89686 | 4.1% |
| T | 85211 | 3.9% |
| Other values (15) | 529244 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 127879 | |
| ' | 8213 | 6.0% |
| ¿ | 578 | 0.4% |
| / | 36 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1878283 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 73925 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 55555 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 53208 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17779492 | |
| Common | 2197677 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2120751 | |
| r | 1379836 | 7.8% |
| a | 1323156 | 7.4% |
| t | 1321203 | 7.4% |
| n | 1310268 | 7.4% |
| i | 1308803 | 7.4% |
| s | 1140870 | 6.4% |
| o | 1013258 | 5.7% |
| c | 833558 | 4.7% |
| l | 820516 | 4.6% |
| Other values (41) | 5207273 |
Common
| Value | Count | Frequency (%) |
| 1878283 | ||
| , | 127879 | 5.8% |
| - | 73925 | 3.4% |
| ( | 55555 | 2.5% |
| ) | 53208 | 2.4% |
| ' | 8213 | 0.4% |
| ¿ | 578 | < 0.1% |
| / | 36 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19976591 | |
| None | 578 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 2120751 | 10.6% |
| 1878283 | 9.4% | |
| r | 1379836 | 6.9% |
| a | 1323156 | 6.6% |
| t | 1321203 | 6.6% |
| n | 1310268 | 6.6% |
| i | 1308803 | 6.6% |
| s | 1140870 | 5.7% |
| o | 1013258 | 5.1% |
| c | 833558 | 4.2% |
| Other values (48) | 6346605 |
None
| Value | Count | Frequency (%) |
| ¿ | 578 |
FranchiseCode
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 5444 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 534676 |
| Missing (%) | 90.9% |
| Memory size | 4.5 MiB |
| 13680 | 650 |
|---|---|
| 78760 | 649 |
| 10245 | 407 |
| 11965 | 393 |
| 13913 | 351 |
| Other values (5439) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 266885 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1816 ? |
|---|---|
| Unique (%) | 3.4% |
Sample
| 1st row | 03512 |
|---|---|
| 2nd row | 06560 |
| 3rd row | 79140 |
| 4th row | 04154 |
| 5th row | 70552 |
Common Values
| Value | Count | Frequency (%) |
| 13680 | 650 | 0.1% |
| 78760 | 649 | 0.1% |
| 10245 | 407 | 0.1% |
| 11965 | 393 | 0.1% |
| 13913 | 351 | 0.1% |
| 13593 | 322 | 0.1% |
| 12645 | 306 | 0.1% |
| 13058 | 299 | 0.1% |
| S1639 | 297 | 0.1% |
| S0122 | 256 | < 0.1% |
| Other values (5434) | 49447 | 8.4% |
| (Missing) | 534676 |
Length
| Value | Count | Frequency (%) |
| 13680 | 650 | 1.2% |
| 78760 | 649 | 1.2% |
| 10245 | 407 | 0.8% |
| 11965 | 393 | 0.7% |
| 13913 | 351 | 0.7% |
| 13593 | 322 | 0.6% |
| 12645 | 306 | 0.6% |
| 13058 | 299 | 0.6% |
| s1639 | 298 | 0.6% |
| s0122 | 257 | 0.5% |
| Other values (5372) | 49445 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 54931 | |
| 0 | 32727 | |
| 3 | 25257 | |
| 2 | 25146 | |
| 5 | 21962 | 8.2% |
| 4 | 19836 | 7.4% |
| S | 18548 | 6.9% |
| 9 | 17809 | 6.7% |
| 6 | 17231 | 6.5% |
| 7 | 17216 | 6.5% |
| Other values (2) | 16222 | 6.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 248258 | |
| Uppercase Letter | 18548 | 6.9% |
| Lowercase Letter | 79 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 54931 | |
| 0 | 32727 | |
| 3 | 25257 | |
| 2 | 25146 | |
| 5 | 21962 | 8.8% |
| 4 | 19836 | 8.0% |
| 9 | 17809 | 7.2% |
| 6 | 17231 | 6.9% |
| 7 | 17216 | 6.9% |
| 8 | 16143 | 6.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 18548 |
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 79 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 248258 | |
| Latin | 18627 | 7.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 54931 | |
| 0 | 32727 | |
| 3 | 25257 | |
| 2 | 25146 | |
| 5 | 21962 | 8.8% |
| 4 | 19836 | 8.0% |
| 9 | 17809 | 7.2% |
| 6 | 17231 | 6.9% |
| 7 | 17216 | 6.9% |
| 8 | 16143 | 6.5% |
Latin
| Value | Count | Frequency (%) |
| S | 18548 | |
| s | 79 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 266885 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 54931 | |
| 0 | 32727 | |
| 3 | 25257 | |
| 2 | 25146 | |
| 5 | 21962 | 8.2% |
| 4 | 19836 | 7.4% |
| S | 18548 | 6.9% |
| 9 | 17809 | 6.7% |
| 6 | 17231 | 6.5% |
| 7 | 17216 | 6.5% |
| Other values (2) | 16222 | 6.1% |
FranchiseName
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 4768 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 534790 |
| Missing (%) | 90.9% |
| Memory size | 4.5 MiB |
| SUBWAY | 650 |
|---|---|
| SUBWAY SANDWICH SHOP | 649 |
| JIMMY JOHN'S | 593 |
| ANYTIME FITNESS | 571 |
| THE UPS STORE | 432 |
| Other values (4763) |
Length
| Max length | 30 |
|---|---|
| Median length | 23 |
| Mean length | 16.085857 |
| Min length | 3 |
Characters and Unicode
| Total characters | 856781 |
|---|---|
| Distinct characters | 86 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1478 ? |
|---|---|
| Unique (%) | 2.8% |
Sample
| 1st row | ALPHAGRAPHICS, PRINTSHOPS OF T |
|---|---|
| 2nd row | AUNTIE ANN'S (SOFT PRETZELS) |
| 3rd row | SUPER 8 MOTEL |
| 4th row | AMERIPRISE FINANCIAL SERVICES |
| 5th row | RODEWAY INNS |
Common Values
| Value | Count | Frequency (%) |
| SUBWAY | 650 | 0.1% |
| SUBWAY SANDWICH SHOP | 649 | 0.1% |
| JIMMY JOHN'S | 593 | 0.1% |
| ANYTIME FITNESS | 571 | 0.1% |
| THE UPS STORE | 432 | 0.1% |
| FIREHOUSE SUBS | 363 | 0.1% |
| DAYS INN | 327 | 0.1% |
| SPORT CLIPS | 322 | 0.1% |
| MASSAGE ENVY | 312 | 0.1% |
| ORANGE THEORY FITNESS | 306 | 0.1% |
| Other values (4758) | 48738 | 8.3% |
| (Missing) | 534790 |
Length
| Value | Count | Frequency (%) |
| inn | 2851 | 2.1% |
| the | 2804 | 2.1% |
| 2672 | 2.0% | |
| pizza | 2060 | 1.5% |
| fitness | 1839 | 1.4% |
| subway | 1596 | 1.2% |
| suites | 1152 | 0.9% |
| shop | 879 | 0.7% |
| john's | 871 | 0.7% |
| anytime | 860 | 0.6% |
| Other values (4597) | 116304 |
Most occurring characters
| Value | Count | Frequency (%) |
| 80516 | 9.4% | |
| E | 51306 | 6.0% |
| S | 49245 | 5.7% |
| A | 42850 | 5.0% |
| I | 39561 | 4.6% |
| T | 35445 | 4.1% |
| N | 34652 | 4.0% |
| R | 34419 | 4.0% |
| O | 32337 | 3.8% |
| e | 28794 | 3.4% |
| Other values (76) | 427656 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 527563 | |
| Lowercase Letter | 225274 | |
| Space Separator | 80851 | 9.4% |
| Other Punctuation | 14287 | 1.7% |
| Decimal Number | 3640 | 0.4% |
| Dash Punctuation | 2651 | 0.3% |
| Open Punctuation | 1525 | 0.2% |
| Close Punctuation | 847 | 0.1% |
| Math Symbol | 133 | < 0.1% |
| Other Symbol | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 28794 | |
| a | 20307 | 9.0% |
| r | 19462 | 8.6% |
| i | 18668 | 8.3% |
| o | 18616 | 8.3% |
| n | 17930 | 8.0% |
| t | 15067 | 6.7% |
| s | 14487 | 6.4% |
| l | 10386 | 4.6% |
| u | 8246 | 3.7% |
| Other values (18) | 53311 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 51306 | 9.7% |
| S | 49245 | 9.3% |
| A | 42850 | 8.1% |
| I | 39561 | 7.5% |
| T | 35445 | 6.7% |
| N | 34652 | 6.6% |
| R | 34419 | 6.5% |
| O | 32337 | 6.1% |
| C | 25876 | 4.9% |
| L | 20320 | 3.9% |
| Other values (17) | 161552 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 7020 | |
| / | 2232 | 15.6% |
| & | 2156 | 15.1% |
| . | 1906 | 13.3% |
| , | 772 | 5.4% |
| ! | 135 | 0.9% |
| ¿ | 30 | 0.2% |
| ? | 23 | 0.2% |
| # | 8 | 0.1% |
| % | 3 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 747 | |
| 1 | 640 | |
| 6 | 610 | |
| 0 | 452 | |
| 4 | 281 | 7.7% |
| 5 | 232 | 6.4% |
| 2 | 209 | 5.7% |
| 3 | 205 | 5.6% |
| 9 | 170 | 4.7% |
| 7 | 94 | 2.6% |
Space Separator
| Value | Count | Frequency (%) |
| 80516 | ||
| Â | 335 | 0.4% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 127 | |
| = | 6 | 4.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2651 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1525 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 847 |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 8 |
Other Number
| Value | Count | Frequency (%) |
| ² | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 752837 | |
| Common | 103944 | 12.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 51306 | 6.8% |
| S | 49245 | 6.5% |
| A | 42850 | 5.7% |
| I | 39561 | 5.3% |
| T | 35445 | 4.7% |
| N | 34652 | 4.6% |
| R | 34419 | 4.6% |
| O | 32337 | 4.3% |
| e | 28794 | 3.8% |
| C | 25876 | 3.4% |
| Other values (45) | 378352 |
Common
| Value | Count | Frequency (%) |
| 80516 | ||
| ' | 7020 | 6.8% |
| - | 2651 | 2.6% |
| / | 2232 | 2.1% |
| & | 2156 | 2.1% |
| . | 1906 | 1.8% |
| ( | 1525 | 1.5% |
| ) | 847 | 0.8% |
| , | 772 | 0.7% |
| 8 | 747 | 0.7% |
| Other values (21) | 3572 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 856378 | |
| None | 403 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 80516 | 9.4% | |
| E | 51306 | 6.0% |
| S | 49245 | 5.8% |
| A | 42850 | 5.0% |
| I | 39561 | 4.6% |
| T | 35445 | 4.1% |
| N | 34652 | 4.0% |
| R | 34419 | 4.0% |
| O | 32337 | 3.8% |
| e | 28794 | 3.4% |
| Other values (68) | 427253 |
None
| Value | Count | Frequency (%) |
| Â | 335 | |
| ¿ | 30 | 7.4% |
| é | 12 | 3.0% |
| É | 9 | 2.2% |
| ® | 8 | 2.0% |
| ö | 6 | 1.5% |
| ² | 2 | 0.5% |
| · | 1 | 0.2% |
ProjectCounty
Categorical
| Distinct | 1889 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| LOS ANGELES | 22751 |
|---|---|
| ORANGE | 11133 |
| COOK | 8888 |
| MARICOPA | 8474 |
| HARRIS | 8340 |
| Other values (1884) |
Length
| Max length | 25 |
|---|---|
| Median length | 20 |
| Mean length | 7.511607 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4417208 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 54 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DENVER |
|---|---|
| 2nd row | SACRAMENTO |
| 3rd row | YOLO |
| 4th row | FAIRFIELD |
| 5th row | ELKHART |
Common Values
| Value | Count | Frequency (%) |
| LOS ANGELES | 22751 | 3.9% |
| ORANGE | 11133 | 1.9% |
| COOK | 8888 | 1.5% |
| MARICOPA | 8474 | 1.4% |
| HARRIS | 8340 | 1.4% |
| SAN DIEGO | 6883 | 1.2% |
| MONTGOMERY | 6784 | 1.2% |
| MIDDLESEX | 6654 | 1.1% |
| FRANKLIN | 6222 | 1.1% |
| JEFFERSON | 6099 | 1.0% |
| Other values (1879) | 495823 |
Length
| Value | Count | Frequency (%) |
| los | 22764 | 3.3% |
| angeles | 22751 | 3.3% |
| san | 16887 | 2.5% |
| orange | 11133 | 1.6% |
| cook | 8888 | 1.3% |
| maricopa | 8474 | 1.2% |
| harris | 8340 | 1.2% |
| new | 8154 | 1.2% |
| lake | 7858 | 1.2% |
| diego | 6883 | 1.0% |
| Other values (1907) | 559221 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 513339 | |
| E | 434906 | 9.8% |
| N | 386797 | 8.8% |
| O | 364196 | 8.2% |
| R | 296063 | 6.7% |
| S | 290357 | 6.6% |
| L | 290334 | 6.6% |
| I | 241762 | 5.5% |
| T | 180178 | 4.1% |
| M | 150406 | 3.4% |
| Other values (22) | 1268870 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4319180 | |
| Space Separator | 93302 | 2.1% |
| Dash Punctuation | 4711 | 0.1% |
| Lowercase Letter | 15 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 513339 | |
| E | 434906 | 10.1% |
| N | 386797 | 9.0% |
| O | 364196 | 8.4% |
| R | 296063 | 6.9% |
| S | 290357 | 6.7% |
| L | 290334 | 6.7% |
| I | 241762 | 5.6% |
| T | 180178 | 4.2% |
| M | 150406 | 3.5% |
| Other values (16) | 1170842 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6 | |
| i | 3 | |
| p | 3 | |
| n | 3 |
Space Separator
| Value | Count | Frequency (%) |
| 93302 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4711 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4319195 | |
| Common | 98013 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 513339 | |
| E | 434906 | 10.1% |
| N | 386797 | 9.0% |
| O | 364196 | 8.4% |
| R | 296063 | 6.9% |
| S | 290357 | 6.7% |
| L | 290334 | 6.7% |
| I | 241762 | 5.6% |
| T | 180178 | 4.2% |
| M | 150406 | 3.5% |
| Other values (20) | 1170857 |
Common
| Value | Count | Frequency (%) |
| 93302 | ||
| - | 4711 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4417208 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 513339 | |
| E | 434906 | 9.8% |
| N | 386797 | 8.8% |
| O | 364196 | 8.2% |
| R | 296063 | 6.7% |
| S | 290357 | 6.6% |
| L | 290334 | 6.6% |
| I | 241762 | 5.5% |
| T | 180178 | 4.1% |
| M | 150406 | 3.4% |
| Other values (22) | 1268870 |
ProjectState
Categorical
HIGH CARDINALITY  HIGH CORRELATION 
| Distinct | 58 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| CA | |
|---|---|
| TX | |
| NY | |
| OH | 33473 |
| FL | 28650 |
| Other values (53) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1176106 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CO |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CT |
| 5th row | IN |
Common Values
| Value | Count | Frequency (%) |
| CA | 73437 | 12.5% |
| TX | 44815 | 7.6% |
| NY | 37465 | 6.4% |
| OH | 33473 | 5.7% |
| FL | 28650 | 4.9% |
| MI | 22983 | 3.9% |
| MA | 20765 | 3.5% |
| IL | 19460 | 3.3% |
| PA | 18831 | 3.2% |
| MN | 16980 | 2.9% |
| Other values (48) | 271194 |
Length
| Value | Count | Frequency (%) |
| ca | 73437 | 12.5% |
| tx | 44815 | 7.6% |
| ny | 37465 | 6.4% |
| oh | 33473 | 5.7% |
| fl | 28650 | 4.9% |
| mi | 22983 | 3.9% |
| ma | 20765 | 3.5% |
| il | 19460 | 3.3% |
| pa | 18831 | 3.2% |
| mn | 16980 | 2.9% |
| Other values (48) | 271194 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 183962 | |
| N | 119602 | |
| C | 111818 | 9.5% |
| M | 94427 | 8.0% |
| I | 87963 | 7.5% |
| T | 74075 | 6.3% |
| O | 72675 | 6.2% |
| L | 56877 | 4.8% |
| X | 44815 | 3.8% |
| Y | 43966 | 3.7% |
| Other values (14) | 285926 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1176106 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 183962 | |
| N | 119602 | |
| C | 111818 | 9.5% |
| M | 94427 | 8.0% |
| I | 87963 | 7.5% |
| T | 74075 | 6.3% |
| O | 72675 | 6.2% |
| L | 56877 | 4.8% |
| X | 44815 | 3.8% |
| Y | 43966 | 3.7% |
| Other values (14) | 285926 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1176106 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 183962 | |
| N | 119602 | |
| C | 111818 | 9.5% |
| M | 94427 | 8.0% |
| I | 87963 | 7.5% |
| T | 74075 | 6.3% |
| O | 72675 | 6.2% |
| L | 56877 | 4.8% |
| X | 44815 | 3.8% |
| Y | 43966 | 3.7% |
| Other values (14) | 285926 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1176106 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 183962 | |
| N | 119602 | |
| C | 111818 | 9.5% |
| M | 94427 | 8.0% |
| I | 87963 | 7.5% |
| T | 74075 | 6.3% |
| O | 72675 | 6.2% |
| L | 56877 | 4.8% |
| X | 44815 | 3.8% |
| Y | 43966 | 3.7% |
| Other values (14) | 285926 |
SBADistrictOffice
Categorical
HIGH CARDINALITY  HIGH CORRELATION 
| Distinct | 74 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| LOS ANGELES DISTRICT OFFICEÂ | 24831 |
|---|---|
| MICHIGAN DISTRICT OFFICEÂ | 22982 |
| SOUTH FLORIDA DISTRICT OFFICEÂ | 20482 |
| ILLINOIS DISTRICT OFFICEÂ | 19458 |
| MASSACHUSETTS DISTRICT OFFICEÂ | 18941 |
| Other values (69) |
Length
| Max length | 40 |
|---|---|
| Median length | 34 |
| Mean length | 26.511124 |
| Min length | 21 |
Characters and Unicode
| Total characters | 15589946 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COLORADO DISTRICT OFFICEÂ |
|---|---|
| 2nd row | SACRAMENTO DISTRICT OFFICEÂ |
| 3rd row | SACRAMENTO DISTRICT OFFICEÂ |
| 4th row | CONNECTICUT DISTRICT OFFICEÂ |
| 5th row | INDIANA DISTRICT OFFICEÂ |
Common Values
| Value | Count | Frequency (%) |
| LOS ANGELES DISTRICT OFFICEÂ | 24831 | 4.2% |
| MICHIGAN DISTRICT OFFICEÂ | 22982 | 3.9% |
| SOUTH FLORIDA DISTRICT OFFICEÂ | 20482 | 3.5% |
| ILLINOIS DISTRICT OFFICEÂ | 19458 | 3.3% |
| MASSACHUSETTS DISTRICT OFFICEÂ | 18941 | 3.2% |
| DALLAS / FT WORTH DISTRICT OFFICEÂ | 17796 | 3.0% |
| NEW YORK DISTRICT OFFICEÂ | 17516 | 3.0% |
| MINNESOTA DISTRICT OFFICEÂ | 16980 | 2.9% |
| COLUMBUS DISTRICT OFFICEÂ | 16979 | 2.9% |
| CLEVELAND DISTRICT OFFICEÂ | 16495 | 2.8% |
| Other values (64) | 395593 |
Length
| Value | Count | Frequency (%) |
| office | 588053 | |
| district | 567133 | |
| new | 42164 | 2.1% |
| san | 29532 | 1.5% |
| florida | 28650 | 1.4% |
| south | 26615 | 1.3% |
| los | 24831 | 1.2% |
| angeles | 24831 | 1.2% |
| michigan | 22982 | 1.1% |
| north | 21896 | 1.1% |
| Other values (86) | 642812 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 2168720 | |
| T | 1440496 | |
| 1431446 | ||
| C | 1392928 | |
| F | 1255506 | 8.1% |
| S | 1069339 | 6.9% |
| O | 1067809 | 6.8% |
| E | 981484 | 6.3% |
| R | 863488 | 5.5% |
| D | 729117 | 4.7% |
| Other values (19) | 3189613 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 13547678 | |
| Space Separator | 2019499 | 13.0% |
| Other Punctuation | 22769 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 2168720 | |
| T | 1440496 | |
| C | 1392928 | |
| F | 1255506 | |
| S | 1069339 | |
| O | 1067809 | |
| E | 981484 | |
| R | 863488 | 6.4% |
| D | 729117 | 5.4% |
| A | 664280 | 4.9% |
| Other values (15) | 1914511 |
Space Separator
| Value | Count | Frequency (%) |
| 1431446 | ||
| Â | 588053 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 17796 | |
| . | 4973 | 21.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13547678 | |
| Common | 2042268 | 13.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 2168720 | |
| T | 1440496 | |
| C | 1392928 | |
| F | 1255506 | |
| S | 1069339 | |
| O | 1067809 | |
| E | 981484 | |
| R | 863488 | 6.4% |
| D | 729117 | 5.4% |
| A | 664280 | 4.9% |
| Other values (15) | 1914511 |
Common
| Value | Count | Frequency (%) |
| 1431446 | ||
| Â | 588053 | |
| / | 17796 | 0.9% |
| . | 4973 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15001893 | |
| None | 588053 | 3.8% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 2168720 | |
| T | 1440496 | |
| 1431446 | ||
| C | 1392928 | |
| F | 1255506 | |
| S | 1069339 | |
| O | 1067809 | |
| E | 981484 | 6.5% |
| R | 863488 | 5.8% |
| D | 729117 | 4.9% |
| Other values (18) | 2601560 |
None
| Value | Count | Frequency (%) |
| Â | 588053 |
CongressionalDistrict
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.241255 |
| Minimum | 0 |
|---|---|
| Maximum | 53 |
| Zeros | 19793 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 13 |
| 95-th percentile | 35 |
| Maximum | 53 |
| Range | 53 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 11.014161 |
|---|---|
| Coefficient of variation (CV) | 1.0754699 |
| Kurtosis | 2.9598985 |
| Mean | 10.241255 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.7992169 |
| Sum | 6022042 |
| Variance | 121.31173 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58261 | 9.9% |
| 2 | 55536 | 9.4% |
| 3 | 49998 | 8.5% |
| 4 | 43294 | 7.4% |
| 6 | 36697 | 6.2% |
| 5 | 36671 | 6.2% |
| 7 | 35706 | 6.1% |
| 8 | 26399 | 4.5% |
| 9 | 22340 | 3.8% |
| 0 | 19793 | 3.4% |
| Other values (44) | 203323 |
| Value | Count | Frequency (%) |
| 0 | 19793 | 3.4% |
| 1 | 58261 | |
| 2 | 55536 | |
| 3 | 49998 | |
| 4 | 43294 | |
| 5 | 36671 | |
| 6 | 36697 | |
| 7 | 35706 | |
| 8 | 26399 | |
| 9 | 22340 | 3.8% |
| Value | Count | Frequency (%) |
| 53 | 1593 | |
| 52 | 1977 | |
| 51 | 974 | |
| 50 | 1051 | |
| 49 | 1977 | |
| 48 | 1703 | |
| 47 | 1539 | |
| 46 | 1506 | |
| 45 | 2374 | |
| 44 | 1241 |
BusinessType
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| CORPORATION | |
|---|---|
| INDIVIDUAL | |
| PARTNERSHIP | 10414 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.895493 |
| Min length | 10 |
Characters and Unicode
| Total characters | 6407073 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CORPORATION |
|---|---|
| 2nd row | CORPORATION |
| 3rd row | CORPORATION |
| 4th row | CORPORATION |
| 5th row | INDIVIDUAL |
Common Values
| Value | Count | Frequency (%) |
| CORPORATION | 516179 | |
| INDIVIDUAL | 61455 | 10.5% |
| PARTNERSHIP | 10414 | 1.8% |
| (Missing) | 5 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| corporation | 516179 | |
| individual | 61455 | 10.5% |
| partnership | 10414 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 1548537 | |
| R | 1053186 | |
| I | 710958 | |
| A | 588048 | 9.2% |
| N | 588048 | 9.2% |
| P | 537007 | 8.4% |
| T | 526593 | 8.2% |
| C | 516179 | 8.1% |
| D | 122910 | 1.9% |
| V | 61455 | 1.0% |
| Other values (5) | 154152 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6407073 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1548537 | |
| R | 1053186 | |
| I | 710958 | |
| A | 588048 | 9.2% |
| N | 588048 | 9.2% |
| P | 537007 | 8.4% |
| T | 526593 | 8.2% |
| C | 516179 | 8.1% |
| D | 122910 | 1.9% |
| V | 61455 | 1.0% |
| Other values (5) | 154152 | 2.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6407073 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 1548537 | |
| R | 1053186 | |
| I | 710958 | |
| A | 588048 | 9.2% |
| N | 588048 | 9.2% |
| P | 537007 | 8.4% |
| T | 526593 | 8.2% |
| C | 516179 | 8.1% |
| D | 122910 | 1.9% |
| V | 61455 | 1.0% |
| Other values (5) | 154152 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6407073 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 1548537 | |
| R | 1053186 | |
| I | 710958 | |
| A | 588048 | 9.2% |
| N | 588048 | 9.2% |
| P | 537007 | 8.4% |
| T | 526593 | 8.2% |
| C | 516179 | 8.1% |
| D | 122910 | 1.9% |
| V | 61455 | 1.0% |
| Other values (5) | 154152 | 2.4% |
LoanStatus
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| EXEMPT | |
|---|---|
| PIF | |
| CANCLD | |
| CHGOFF | 20670 |
| COMMIT | 15795 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 4.8631586 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2859795 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PIF |
|---|---|
| 2nd row | PIF |
| 3rd row | CHGOFF |
| 4th row | EXEMPT |
| 5th row | PIF |
Common Values
| Value | Count | Frequency (%) |
| EXEMPT | 262008 | |
| PIF | 222841 | |
| CANCLD | 66739 | 11.3% |
| CHGOFF | 20670 | 3.5% |
| COMMIT | 15795 | 2.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| exempt | 262008 | |
| pif | 222841 | |
| cancld | 66739 | 11.3% |
| chgoff | 20670 | 3.5% |
| commit | 15795 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 524016 | |
| P | 484849 | |
| M | 293598 | |
| T | 277803 | |
| F | 264181 | |
| X | 262008 | |
| I | 238636 | |
| C | 169943 | 5.9% |
| A | 66739 | 2.3% |
| N | 66739 | 2.3% |
| Other values (5) | 211283 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2859795 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 524016 | |
| P | 484849 | |
| M | 293598 | |
| T | 277803 | |
| F | 264181 | |
| X | 262008 | |
| I | 238636 | |
| C | 169943 | 5.9% |
| A | 66739 | 2.3% |
| N | 66739 | 2.3% |
| Other values (5) | 211283 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2859795 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 524016 | |
| P | 484849 | |
| M | 293598 | |
| T | 277803 | |
| F | 264181 | |
| X | 262008 | |
| I | 238636 | |
| C | 169943 | 5.9% |
| A | 66739 | 2.3% |
| N | 66739 | 2.3% |
| Other values (5) | 211283 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2859795 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 524016 | |
| P | 484849 | |
| M | 293598 | |
| T | 277803 | |
| F | 264181 | |
| X | 262008 | |
| I | 238636 | |
| C | 169943 | 5.9% |
| A | 66739 | 2.3% |
| N | 66739 | 2.3% |
| Other values (5) | 211283 |
PaidInFullDate
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 130 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 365212 |
| Missing (%) | 62.1% |
| Memory size | 4.5 MiB |
| 31-10-2019 | 3819 |
|---|---|
| 31-12-2019 | 3779 |
| 30-04-2019 | 3604 |
| 31-12-2017 | 3516 |
| 31-08-2019 | 3484 |
| Other values (125) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 2228410 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 31-10-2016 |
|---|---|
| 2nd row | 31-03-2019 |
| 3rd row | 28-02-2013 |
| 4th row | 31-10-2019 |
| 5th row | 31-03-2017 |
Common Values
| Value | Count | Frequency (%) |
| 31-10-2019 | 3819 | 0.6% |
| 31-12-2019 | 3779 | 0.6% |
| 30-04-2019 | 3604 | 0.6% |
| 31-12-2017 | 3516 | 0.6% |
| 31-08-2019 | 3484 | 0.6% |
| 30-09-2019 | 3444 | 0.6% |
| 31-08-2018 | 3440 | 0.6% |
| 31-05-2019 | 3430 | 0.6% |
| 31-03-2019 | 3413 | 0.6% |
| 31-10-2018 | 3357 | 0.6% |
| Other values (120) | 187555 | |
| (Missing) | 365212 |
Length
| Value | Count | Frequency (%) |
| 31-10-2019 | 3819 | 1.7% |
| 31-12-2019 | 3779 | 1.7% |
| 30-04-2019 | 3604 | 1.6% |
| 31-12-2017 | 3516 | 1.6% |
| 31-08-2019 | 3484 | 1.6% |
| 30-09-2019 | 3444 | 1.5% |
| 31-08-2018 | 3440 | 1.5% |
| 31-05-2019 | 3430 | 1.5% |
| 31-03-2019 | 3413 | 1.5% |
| 31-10-2018 | 3357 | 1.5% |
| Other values (120) | 187555 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 501929 | |
| - | 445682 | |
| 1 | 427536 | |
| 2 | 306218 | |
| 3 | 236980 | |
| 8 | 70198 | 3.2% |
| 9 | 63765 | 2.9% |
| 7 | 52773 | 2.4% |
| 6 | 46109 | 2.1% |
| 5 | 41707 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1782728 | |
| Dash Punctuation | 445682 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 501929 | |
| 1 | 427536 | |
| 2 | 306218 | |
| 3 | 236980 | |
| 8 | 70198 | 3.9% |
| 9 | 63765 | 3.6% |
| 7 | 52773 | 3.0% |
| 6 | 46109 | 2.6% |
| 5 | 41707 | 2.3% |
| 4 | 35513 | 2.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 445682 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2228410 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 501929 | |
| - | 445682 | |
| 1 | 427536 | |
| 2 | 306218 | |
| 3 | 236980 | |
| 8 | 70198 | 3.2% |
| 9 | 63765 | 2.9% |
| 7 | 52773 | 2.4% |
| 6 | 46109 | 2.1% |
| 5 | 41707 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2228410 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 501929 | |
| - | 445682 | |
| 1 | 427536 | |
| 2 | 306218 | |
| 3 | 236980 | |
| 8 | 70198 | 3.2% |
| 9 | 63765 | 2.9% |
| 7 | 52773 | 2.4% |
| 6 | 46109 | 2.1% |
| 5 | 41707 | 1.9% |
ChargeOffDate
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 2184 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 567384 |
| Missing (%) | 96.5% |
| Memory size | 4.5 MiB |
| 22-02-2019 | 70 |
|---|---|
| 24-03-2020 | 69 |
| 07-02-2019 | 59 |
| 03-03-2020 | 56 |
| 12-02-2019 | 56 |
| Other values (2179) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 206690 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 243 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | 24-08-2015 |
|---|---|
| 2nd row | 16-05-2016 |
| 3rd row | 12-02-2018 |
| 4th row | 01-03-2011 |
| 5th row | 03-12-2012 |
Common Values
| Value | Count | Frequency (%) |
| 22-02-2019 | 70 | < 0.1% |
| 24-03-2020 | 69 | < 0.1% |
| 07-02-2019 | 59 | < 0.1% |
| 03-03-2020 | 56 | < 0.1% |
| 12-02-2019 | 56 | < 0.1% |
| 15-03-2018 | 51 | < 0.1% |
| 16-03-2017 | 49 | < 0.1% |
| 02-01-2018 | 48 | < 0.1% |
| 14-02-2019 | 47 | < 0.1% |
| 12-03-2018 | 47 | < 0.1% |
| Other values (2174) | 20117 | 3.4% |
| (Missing) | 567384 |
Length
| Value | Count | Frequency (%) |
| 22-02-2019 | 70 | 0.3% |
| 24-03-2020 | 69 | 0.3% |
| 07-02-2019 | 59 | 0.3% |
| 03-03-2020 | 56 | 0.3% |
| 12-02-2019 | 56 | 0.3% |
| 15-03-2018 | 51 | 0.2% |
| 16-03-2017 | 49 | 0.2% |
| 02-01-2018 | 48 | 0.2% |
| 14-02-2019 | 47 | 0.2% |
| 12-03-2018 | 47 | 0.2% |
| Other values (2174) | 20117 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 48909 | |
| - | 41338 | |
| 2 | 35839 | |
| 1 | 34700 | |
| 8 | 7727 | 3.7% |
| 9 | 7709 | 3.7% |
| 7 | 6581 | 3.2% |
| 6 | 6516 | 3.2% |
| 3 | 6250 | 3.0% |
| 5 | 5784 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 165352 | |
| Dash Punctuation | 41338 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 48909 | |
| 2 | 35839 | |
| 1 | 34700 | |
| 8 | 7727 | 4.7% |
| 9 | 7709 | 4.7% |
| 7 | 6581 | 4.0% |
| 6 | 6516 | 3.9% |
| 3 | 6250 | 3.8% |
| 5 | 5784 | 3.5% |
| 4 | 5337 | 3.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 41338 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 206690 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 48909 | |
| - | 41338 | |
| 2 | 35839 | |
| 1 | 34700 | |
| 8 | 7727 | 3.7% |
| 9 | 7709 | 3.7% |
| 7 | 6581 | 3.2% |
| 6 | 6516 | 3.2% |
| 3 | 6250 | 3.0% |
| 5 | 5784 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 206690 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 48909 | |
| - | 41338 | |
| 2 | 35839 | |
| 1 | 34700 | |
| 8 | 7727 | 3.7% |
| 9 | 7709 | 3.7% |
| 7 | 6581 | 3.2% |
| 6 | 6516 | 3.2% |
| 3 | 6250 | 3.0% |
| 5 | 5784 | 2.8% |
GrossChargeOffAmount
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 17960 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4305.2546 |
| Minimum | 0 |
|---|---|
| Maximum | 4706180 |
| Zeros | 567384 |
| Zeros (%) | 96.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4706180 |
| Range | 4706180 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 50350.344 |
|---|---|
| Coefficient of variation (CV) | 11.695091 |
| Kurtosis | 1388.0567 |
| Mean | 4305.2546 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 29.433801 |
| Sum | 2.5317179 × 109 |
| Variance | 2.5351571 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 567384 | |
| 25000 | 181 | < 0.1% |
| 50000 | 99 | < 0.1% |
| 10000 | 92 | < 0.1% |
| 100000 | 59 | < 0.1% |
| 20000 | 53 | < 0.1% |
| 15000 | 42 | < 0.1% |
| 24999 | 31 | < 0.1% |
| 5000 | 29 | < 0.1% |
| 350000 | 27 | < 0.1% |
| Other values (17950) | 20056 | 3.4% |
| Value | Count | Frequency (%) |
| 0 | 567384 | |
| 11 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 98 | 1 | < 0.1% |
| 109 | 1 | < 0.1% |
| 179 | 1 | < 0.1% |
| 184 | 1 | < 0.1% |
| 223 | 1 | < 0.1% |
| 228 | 1 | < 0.1% |
| 250 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4706180 | 1 | |
| 4334490 | 1 | |
| 4254436 | 1 | |
| 4084959 | 1 | |
| 4002876 | 1 | |
| 3867035 | 1 | |
| 3730328 | 1 | |
| 3498136 | 1 | |
| 3418147 | 1 | |
| 3403551 | 1 |
RevolverStatus
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 588053 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 588053 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 588053 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 588053 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 402998 | |
| 1 | 185055 |
JobsSupported
Real number (ℝ)
| Distinct | 312 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.720804 |
| Minimum | 0 |
|---|---|
| Maximum | 2150 |
| Zeros | 93989 |
| Zeros (%) | 16.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 11 |
| 95-th percentile | 41 |
| Maximum | 2150 |
| Range | 2150 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 20.425223 |
|---|---|
| Coefficient of variation (CV) | 1.9051951 |
| Kurtosis | 290.78397 |
| Mean | 10.720804 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 8.1718161 |
| Sum | 6304401 |
| Variance | 417.18973 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 93989 | |
| 2 | 65142 | 11.1% |
| 1 | 48415 | 8.2% |
| 4 | 43341 | 7.4% |
| 3 | 42502 | 7.2% |
| 5 | 33952 | 5.8% |
| 6 | 29927 | 5.1% |
| 10 | 23149 | 3.9% |
| 8 | 20835 | 3.5% |
| 7 | 19374 | 3.3% |
| Other values (302) | 167427 |
| Value | Count | Frequency (%) |
| 0 | 93989 | |
| 1 | 48415 | |
| 2 | 65142 | |
| 3 | 42502 | |
| 4 | 43341 | |
| 5 | 33952 | 5.8% |
| 6 | 29927 | 5.1% |
| 7 | 19374 | 3.3% |
| 8 | 20835 | 3.5% |
| 9 | 11759 | 2.0% |
| Value | Count | Frequency (%) |
| 2150 | 1 | |
| 1155 | 1 | |
| 1011 | 1 | |
| 850 | 1 | |
| 750 | 1 | |
| 725 | 1 | |
| 600 | 1 | |
| 570 | 1 | |
| 480 | 1 | |
| 460 | 2 |
| BorrZip | GrossApproval | SBAGuaranteedApproval | ApprovalFiscalYear | InitialInterestRate | TermInMonths | NaicsCode | CongressionalDistrict | GrossChargeOffAmount | JobsSupported | BorrState | BankState | DeliveryMethod | subpgmdesc | ProjectState | SBADistrictOffice | BusinessType | LoanStatus | RevolverStatus | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BorrZip | 1.000 | 0.102 | 0.111 | -0.011 | 0.010 | 0.115 | -0.002 | 0.135 | 0.002 | 0.057 | 0.956 | 0.566 | 0.104 | 0.095 | 0.955 | 0.951 | 0.089 | 0.034 | 0.115 |
| GrossApproval | 0.102 | 1.000 | 0.993 | 0.071 | -0.413 | 0.597 | 0.057 | 0.054 | -0.078 | 0.437 | 0.064 | 0.103 | 0.196 | 0.195 | 0.064 | 0.066 | 0.059 | 0.053 | 0.306 |
| SBAGuaranteedApproval | 0.111 | 0.993 | 1.000 | 0.064 | -0.408 | 0.618 | 0.068 | 0.049 | -0.071 | 0.436 | 0.054 | 0.089 | 0.174 | 0.174 | 0.054 | 0.056 | 0.050 | 0.041 | 0.239 |
| ApprovalFiscalYear | -0.011 | 0.071 | 0.064 | 1.000 | 0.220 | 0.171 | 0.028 | 0.032 | -0.117 | -0.051 | 0.042 | 0.084 | 0.144 | 0.140 | 0.042 | 0.046 | 0.054 | 0.352 | 0.059 |
| InitialInterestRate | 0.010 | -0.413 | -0.408 | 0.220 | 1.000 | -0.112 | -0.003 | 0.017 | 0.056 | -0.191 | 0.087 | 0.162 | 0.154 | 0.153 | 0.087 | 0.095 | 0.064 | 0.084 | 0.377 |
| TermInMonths | 0.115 | 0.597 | 0.618 | 0.171 | -0.112 | 1.000 | 0.132 | 0.065 | -0.193 | 0.179 | 0.126 | 0.192 | 0.286 | 0.284 | 0.127 | 0.130 | 0.075 | 0.154 | 0.478 |
| NaicsCode | -0.002 | 0.057 | 0.068 | 0.028 | -0.003 | 0.132 | 1.000 | 0.019 | -0.008 | 0.125 | 0.112 | 0.136 | 0.102 | 0.102 | 0.112 | 0.117 | 0.139 | 0.034 | 0.224 |
| CongressionalDistrict | 0.135 | 0.054 | 0.049 | 0.032 | 0.017 | 0.065 | 0.019 | 1.000 | 0.009 | -0.002 | 0.367 | 0.206 | 0.045 | 0.039 | 0.367 | 0.568 | 0.054 | 0.016 | 0.043 |
| GrossChargeOffAmount | 0.002 | -0.078 | -0.071 | -0.117 | 0.056 | -0.193 | -0.008 | 0.009 | 1.000 | -0.010 | 0.007 | 0.012 | 0.020 | 0.018 | 0.007 | 0.007 | 0.008 | 0.111 | 0.024 |
| JobsSupported | 0.057 | 0.437 | 0.436 | -0.051 | -0.191 | 0.179 | 0.125 | -0.002 | -0.010 | 1.000 | 0.005 | 0.010 | 0.014 | 0.013 | 0.005 | 0.007 | 0.007 | 0.004 | 0.011 |
| BorrState | 0.956 | 0.064 | 0.054 | 0.042 | 0.087 | 0.126 | 0.112 | 0.367 | 0.007 | 0.005 | 1.000 | 0.525 | 0.153 | 0.138 | 0.998 | 0.923 | 0.144 | 0.052 | 0.160 |
| BankState | 0.566 | 0.103 | 0.089 | 0.084 | 0.162 | 0.192 | 0.136 | 0.206 | 0.012 | 0.010 | 0.525 | 1.000 | 0.210 | 0.183 | 0.525 | 0.515 | 0.120 | 0.088 | 0.388 |
| DeliveryMethod | 0.104 | 0.196 | 0.174 | 0.144 | 0.154 | 0.286 | 0.102 | 0.045 | 0.020 | 0.014 | 0.153 | 0.210 | 1.000 | 0.889 | 0.153 | 0.155 | 0.088 | 0.121 | 0.658 |
| subpgmdesc | 0.095 | 0.195 | 0.174 | 0.140 | 0.153 | 0.284 | 0.102 | 0.039 | 0.018 | 0.013 | 0.138 | 0.183 | 0.889 | 1.000 | 0.138 | 0.141 | 0.088 | 0.118 | 0.678 |
| ProjectState | 0.955 | 0.064 | 0.054 | 0.042 | 0.087 | 0.127 | 0.112 | 0.367 | 0.007 | 0.005 | 0.998 | 0.525 | 0.153 | 0.138 | 1.000 | 0.925 | 0.144 | 0.052 | 0.160 |
| SBADistrictOffice | 0.951 | 0.066 | 0.056 | 0.046 | 0.095 | 0.130 | 0.117 | 0.568 | 0.007 | 0.007 | 0.923 | 0.515 | 0.155 | 0.141 | 0.925 | 1.000 | 0.153 | 0.055 | 0.163 |
| BusinessType | 0.089 | 0.059 | 0.050 | 0.054 | 0.064 | 0.075 | 0.139 | 0.054 | 0.008 | 0.007 | 0.144 | 0.120 | 0.088 | 0.088 | 0.144 | 0.153 | 1.000 | 0.035 | 0.032 |
| LoanStatus | 0.034 | 0.053 | 0.041 | 0.352 | 0.084 | 0.154 | 0.034 | 0.016 | 0.111 | 0.004 | 0.052 | 0.088 | 0.121 | 0.118 | 0.052 | 0.055 | 0.035 | 1.000 | 0.087 |
| RevolverStatus | 0.115 | 0.306 | 0.239 | 0.059 | 0.377 | 0.478 | 0.224 | 0.043 | 0.024 | 0.011 | 0.160 | 0.388 | 0.658 | 0.678 | 0.160 | 0.163 | 0.032 | 0.087 | 1.000 |
| AsOfDate | Program | BorrName | BorrStreet | BorrCity | BorrState | BorrZip | BankName | BankStreet | BankCity | BankState | BankZip | GrossApproval | SBAGuaranteedApproval | ApprovalDate | ApprovalFiscalYear | FirstDisbursementDate | DeliveryMethod | subpgmdesc | InitialInterestRate | TermInMonths | NaicsCode | NaicsDescription | FranchiseCode | FranchiseName | ProjectCounty | ProjectState | SBADistrictOffice | CongressionalDistrict | BusinessType | LoanStatus | PaidInFullDate | ChargeOffDate | GrossChargeOffAmount | RevolverStatus | JobsSupported | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20200930 | 7A | CRESA PARTNERS - DENVER, INC. | 7979 E TUFTS AVE PKWY STE 810 | DENVER | CO | 80237 | Zions Bank, A Division of | 1 S Main St | SALT LAKE CITY | UT | 84133 | 250000 | 125000 | 01-10-2009 | 2010 | 01-10-2009 | SBA EXPRES | FA$TRK (Small Loan Express) | 5.26 | 84 | 531210.0 | Offices of Real Estate Agents and Brokers | NaN | NaN | DENVER | CO | COLORADO DISTRICT OFFICE | 1.0 | CORPORATION | PIF | 31-10-2016 | NaN | 0 | 1 | 35 |
| 1 | 20200930 | 7A | The Hilltop Tavern | 4757 Folsom Blvd | Sacramento | CA | 95819 | Plumas Bank | 336 W Main St | QUINCY | CA | 95971 | 233500 | 210150 | 01-10-2009 | 2010 | 01-10-2009 | PLP | Guaranty | 6.00 | 120 | 722410.0 | Drinking Places (Alcoholic Beverages) | NaN | NaN | SACRAMENTO | CA | SACRAMENTO DISTRICT OFFICE | 6.0 | CORPORATION | PIF | 31-03-2019 | NaN | 0 | 0 | 6 |
| 2 | 20200930 | 7A | River City Car Wash LLC | 649 Harbor Blvd | West Sacramento | CA | 95691 | Wells Fargo Bank, National Association | 101 N Philips Ave | SIOUX FALLS | SD | 57104 | 683900 | 615510 | 01-10-2009 | 2010 | 01-11-2009 | PLP | Guaranty | 5.25 | 210 | 811192.0 | Car Washes | NaN | NaN | YOLO | CA | SACRAMENTO DISTRICT OFFICE | 3.0 | CORPORATION | CHGOFF | NaN | 24-08-2015 | 320098 | 0 | 27 |
| 3 | 20200930 | 7A | Alphagraphics | 71 Newtown Road. | Danbury | CT | 6810 | Union Savings Bank | 226 Main St | DANBURY | CT | 6810 | 100000 | 50000 | 01-10-2009 | 2010 | 01-10-2009 | SBA EXPRES | FA$TRK (Small Loan Express) | 5.25 | 84 | 323110.0 | Commercial Lithographic Printing | 03512 | ALPHAGRAPHICS, PRINTSHOPS OF T | FAIRFIELD | CT | CONNECTICUT DISTRICT OFFICE | 5.0 | CORPORATION | EXEMPT | NaN | NaN | 0 | 1 | 5 |
| 4 | 20200930 | 7A | ON SITE AUTOMOTIVE APPEARANCE | 603 WOODBRIDGE COURT | MIDDLEBURY | IN | 46540 | VelocitySBA, LLC | 9385 Haven Avenue | Rancho Cucamonga | CA | 91730 | 12500 | 11250 | 01-10-2009 | 2010 | 01-10-2009 | COMM EXPRS | Community Express | 7.75 | 120 | 811121.0 | Automotive Body, Paint, and Interior Repair and Maintenance | NaN | NaN | ELKHART | IN | INDIANA DISTRICT OFFICE | 3.0 | INDIVIDUAL | PIF | 28-02-2013 | NaN | 0 | 0 | 2 |
| 5 | 20200930 | 7A | AW ENTERPRISES | 106 WEST LAKE STREET | CAMDEN | TN | 38320 | VelocitySBA, LLC | 9385 Haven Avenue | Rancho Cucamonga | CA | 91730 | 10000 | 9000 | 01-10-2009 | 2010 | 01-10-2009 | COMM EXPRS | Community Express | 7.24 | 120 | 453220.0 | Gift, Novelty, and Souvenir Stores | NaN | NaN | BENTON | TN | TENNESSEE DISTRICT OFFICE | 7.0 | INDIVIDUAL | PIF | 31-10-2019 | NaN | 0 | 0 | 3 |
| 6 | 20200930 | 7A | TA SPECIALTY | 331 HEATHERSTONE ROAD | COLUMBIA | SC | 29212 | VelocitySBA, LLC | 9385 Haven Avenue | Rancho Cucamonga | CA | 91730 | 20000 | 18000 | 01-10-2009 | 2010 | 01-10-2009 | PATRIOT EX | Patriot Express | 7.75 | 120 | 541890.0 | Other Services Related to Advertising | NaN | NaN | LEXINGTON | SC | SOUTH CAROLINA DISTRICT OFFICE | 2.0 | INDIVIDUAL | PIF | 31-03-2017 | NaN | 0 | 0 | 4 |
| 7 | 20200930 | 7A | Hansen Concrete, Inc. | 8656 71st Street NE | SPICER | MN | 56288 | Lake Region Bank | 51 Main St | NEW LONDON | MN | 56273 | 200000 | 100000 | 01-10-2009 | 2010 | 01-12-2009 | SBA EXPRES | FA$TRK (Small Loan Express) | 7.50 | 60 | 236220.0 | Commercial and Institutional Building Construction | NaN | NaN | KANDIYOHI | MN | MINNESOTA DISTRICT OFFICE | 7.0 | CORPORATION | PIF | 29-02-2012 | NaN | 0 | 1 | 12 |
| 8 | 20200930 | 7A | SHADIA'S SECRETS INC | 950 GLADES RD 2ND FLOOR | BOCA RATON | FL | 33431 | VelocitySBA, LLC | 9385 Haven Avenue | Rancho Cucamonga | CA | 91730 | 15000 | 13500 | 01-10-2009 | 2010 | 01-10-2009 | COMM EXPRS | Community Express | 7.75 | 120 | 446199.0 | All Other Health and Personal Care Stores | NaN | NaN | PALM BEACH | FL | SOUTH FLORIDA DISTRICT OFFICE | 22.0 | CORPORATION | PIF | 31-10-2019 | NaN | 0 | 0 | 1 |
| 9 | 20200930 | 7A | JT'S COFFEE AND SANDWICH SHOP | 1167 HARRISON STREET | SAN FRANCISCO | CA | 94103 | VelocitySBA, LLC | 9385 Haven Avenue | Rancho Cucamonga | CA | 91730 | 20000 | 18000 | 01-10-2009 | 2010 | 01-10-2009 | COMM EXPRS | Community Express | 7.75 | 120 | 722213.0 | Snack and Nonalcoholic Beverage Bars | NaN | NaN | SAN FRANCISCO | CA | SAN FRANCISCO DISTRICT OFFICE | 12.0 | CORPORATION | PIF | 31-10-2017 | NaN | 0 | 0 | 4 |
| AsOfDate | Program | BorrName | BorrStreet | BorrCity | BorrState | BorrZip | BankName | BankStreet | BankCity | BankState | BankZip | GrossApproval | SBAGuaranteedApproval | ApprovalDate | ApprovalFiscalYear | FirstDisbursementDate | DeliveryMethod | subpgmdesc | InitialInterestRate | TermInMonths | NaicsCode | NaicsDescription | FranchiseCode | FranchiseName | ProjectCounty | ProjectState | SBADistrictOffice | CongressionalDistrict | BusinessType | LoanStatus | PaidInFullDate | ChargeOffDate | GrossChargeOffAmount | RevolverStatus | JobsSupported | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 588043 | 20200930 | 7A | MSA Building LLC | 16535 Grand River Ave | Detroit | MI | 48227 | The Huntington National Bank | 17 S High St | COLUMBUS | OH | 43215.0 | 479400 | 359550 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 6.00 | 180 | 445310.0 | Beer, Wine, and Liquor Stores | NaN | NaN | WAYNE | MI | MICHIGAN DISTRICT OFFICE | 14.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 4 |
| 588044 | 20200930 | 7A | Apponaug Animal Hospital, Inc. | 61 Gilbane Street a/k/a 42 B | Warwick | RI | 2886 | HarborOne Bank | 770 Oak St | BROCKTON | MA | 2301.0 | 180000 | 135000 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 4.25 | 120 | 541940.0 | Veterinary Services | NaN | NaN | KENT | RI | RHODE ISLAND DISTRICT OFFICE | 2.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 6 |
| 588045 | 20200930 | 7A | Brass and rose-Kyle LLC | 5401 FM 1626 #200 | Kyle | TX | 78640 | Wallis Bank | 6510 Railroad St | WALLIS | TX | 77485.0 | 261000 | 195750 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 5.00 | 126 | 812990.0 | All Other Personal Services | S0101 | Amazing Lash Studio | HAYS | TX | SAN ANTONIO DISTRICT OFFICE | 35.0 | PARTNERSHIP | COMMIT | NaN | NaN | 0 | 0 | 52 |
| 588046 | 20200930 | 7A | GODINEZ LOGISTICS LLC | 7704 CLEARWATER AVE W | KENNEWICK | WA | 99336 | U.S. Bank, National Association | 425 Walnut St | CINCINNATI | OH | 45202.0 | 19000 | 9500 | 30-09-2020 | 2020 | NaN | SBA EXPRES | FA$TRK (Small Loan Express) | 5.24 | 60 | 484121.0 | General Freight Trucking, Long Distance, Truckload | NaN | NaN | BENTON | WA | SPOKANE BRANCH OFFICE | 4.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 1 |
| 588047 | 20200930 | 7A | DazDan Foods LLC | 177 Elton Adelphia Road | Freehold | NJ | 7728 | Trenton Business Assistance Corporation | 3111 Quakerbridge Road | Mercerville | NJ | 8619.0 | 200000 | 150000 | 30-09-2020 | 2020 | NaN | CA | Community Advantage Initiative | 5.25 | 120 | 445299.0 | All Other Specialty Food Stores | NaN | NaN | MONMOUTH | NJ | NEW JERSEY DISTRICT OFFICE | 4.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 15 |
| 588048 | 20200930 | 7A | Lincoln Alan Construction Grou | 9120 Crackle Rd | Chagrin Falls | OH | 44023 | The Huntington National Bank | 17 S High St | COLUMBUS | OH | 43215.0 | 200000 | 100000 | 30-09-2020 | 2020 | NaN | SBA EXPRES | FA$TRK (Small Loan Express) | 5.50 | 120 | 236118.0 | Residential Remodelers | NaN | NaN | GEAUGA | OH | CLEVELAND DISTRICT OFFICE | 14.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 1 | 0 |
| 588049 | 20200930 | 7A | PFFL Holdings, LLC | 601 CHURCH ST | NASHVILLE | TN | 37219 | CapStar Bank | 1201 Demonbreun St | NASHVILLE | TN | 37203.0 | 783500 | 587625 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 6.00 | 126 | 722511.0 | Full-Service Restaurants | S3558 | COPPER BRANCH | DAVIDSON | TN | TENNESSEE DISTRICT OFFICE | 5.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 17 |
| 588050 | 20200930 | 7A | PFFL Holdings, LLC | 601 CHURCH ST | NASHVILLE | TN | 37219 | CapStar Bank | 1201 Demonbreun St | NASHVILLE | TN | 37203.0 | 150000 | 75000 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 6.00 | 120 | 722511.0 | Full-Service Restaurants | S3558 | COPPER BRANCH | DAVIDSON | TN | TENNESSEE DISTRICT OFFICE | 5.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 17 |
| 588051 | 20200930 | 7A | Norkobe's Beauty | 701 N STATE ROAD 7 | MARGATE | FL | 33063 | Harvest Small Business Finance, LLC | 24422 Avenida de la Carlota | Laguna Hills | CA | 92653.0 | 620000 | 465000 | 30-09-2020 | 2020 | NaN | PLP | Guaranty | 6.00 | 300 | 812112.0 | Beauty Salons | NaN | NaN | BROWARD | FL | SOUTH FLORIDA DISTRICT OFFICE | 22.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 16 |
| 588052 | 20200930 | 7A | Prestigious Appliance LLC | 1118 Gary Alan Trace | Moody | AL | 35004 | Progress Bank and Trust | 201 Williams Ave | HUNTSVILLE | AL | 35801.0 | 261000 | 195750 | 30-09-2020 | 2020 | NaN | OTH 7A | Guaranty | 6.00 | 120 | 443141.0 | Household Appliance Stores | NaN | NaN | SAINT CLAIR | AL | ALABAMA DISTRICT OFFICE | 3.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 8 |
Most frequently occurring
| AsOfDate | Program | BorrName | BorrStreet | BorrCity | BorrState | BorrZip | BankName | BankStreet | BankCity | BankState | GrossApproval | SBAGuaranteedApproval | ApprovalDate | ApprovalFiscalYear | FirstDisbursementDate | DeliveryMethod | subpgmdesc | InitialInterestRate | TermInMonths | NaicsCode | NaicsDescription | FranchiseCode | FranchiseName | ProjectCounty | ProjectState | SBADistrictOffice | CongressionalDistrict | BusinessType | LoanStatus | PaidInFullDate | ChargeOffDate | GrossChargeOffAmount | RevolverStatus | JobsSupported | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 195 | 20200930 | 7A | Cedar Investments, LLC | 1210 N. Stone Ave. | Tucson | AZ | 85705 | Bank of the West | 180 Montgomery St | SAN FRANCISCO | CA | 277700 | 208275 | 21-10-2019 | 2020 | NaN | PLP | Guaranty | 4.78 | 300 | 561421.0 | Telephone Answering Services | NaN | NaN | PIMA | AZ | ARIZONA DISTRICT OFFICE | 3.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 0 | 8 |
| 904 | 20200930 | 7A | Van Row Mechanical, Inc. | 1225 Avenue C | White City | OR | 97503 | People's Bank of Commerce | 1311 E Barnett Rd | MEDFORD | OR | 60000 | 51000 | 31-10-2011 | 2012 | NaN | PATRIOT EX | Patriot Express | 5.25 | 12 | 238220.0 | Plumbing, Heating, and Air-Conditioning Contractors | NaN | NaN | JACKSON | OR | PORTLAND DISTRICT OFFICE | 2.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 1 | 4 | 8 |
| 339 | 20200930 | 7A | GONZO'S BASIC SOLUTIONS | 1921 EAST CARNEGIE AVE SUITE | SANTA ANA | CA | 92705 | American Plus Bank, National Association | 630 W Duarte Rd | ARCADIA | CA | 445000 | 333750 | 03-10-2012 | 2013 | NaN | PLP | Guaranty | 4.50 | 300 | 424210.0 | Drugs and Druggists' Sundries Merchant Wholesalers | NaN | NaN | ORANGE | CA | SANTA ANA DISTRICT OFFICE | 45.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 2 | 7 |
| 581 | 20200930 | 7A | Martin Bionics Innovations LLC | 214 E. MAIN ST | OKLAHOMA CITY | OK | 73104 | BancFirst | 101 N Broadway, Ste 1050 | OKLAHOMA CITY | OK | 250000 | 187500 | 11-03-2020 | 2020 | NaN | PLP | Guaranty | 5.75 | 84 | 541990.0 | All Other Professional, Scientific, and Technical Services | NaN | NaN | OKLAHOMA | OK | OKLAHOMA DISTRICT OFFICE | 5.0 | CORPORATION | COMMIT | NaN | NaN | 0 | 0 | 50 | 7 |
| 907 | 20200930 | 7A | Vela Transport LLC | 5459 Crippen Ave SW | Wyoming | MI | 49548 | The Huntington National Bank | 17 S High St | COLUMBUS | OH | 21400 | 10700 | 14-03-2014 | 2014 | 01-04-2014 | SBA EXPRES | FA$TRK (Small Loan Express) | 4.90 | 60 | 484230.0 | Specialized Freight (except Used Goods) Trucking, Long-Distance | NaN | NaN | KENT | MI | MICHIGAN DISTRICT OFFICE | 3.0 | CORPORATION | PIF | 30-04-2019 | NaN | 0 | 0 | 4 | 7 |
| 391 | 20200930 | 7A | Happy Start, Inc. | 2280 Bypass 35 | Alvin | TX | 77511 | Texas Advantage Community Bank, National Association | 1701 Fairway Plaza, Ste 18 | ALVIN | TX | 1064000 | 798000 | 05-10-2015 | 2016 | NaN | OTH 7A | Guaranty | 5.50 | 240 | 624410.0 | Child Day Care Services | NaN | NaN | BRAZORIA | TX | HOUSTON DISTRICT OFFICE | 14.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 0 | 6 |
| 499 | 20200930 | 7A | L&E Transport, LLC | 2250 N Whistlevale Dr SW | Bryon Center | MI | 49315 | The Huntington National Bank | 17 S High St | COLUMBUS | OH | 53100 | 26550 | 25-01-2017 | 2017 | 01-02-2017 | SBA EXPRES | FA$TRK (Small Loan Express) | 6.50 | 60 | 484121.0 | General Freight Trucking, Long Distance, Truckload | NaN | NaN | KENT | MI | MICHIGAN DISTRICT OFFICE | 3.0 | CORPORATION | EXEMPT | NaN | NaN | 0 | 0 | 6 | 6 |
| 502 | 20200930 | 7A | LCTC, INC. | 5084 NORTH FRUIT AVENUE SUITE | FRESNO | CA | 93711 | Premier Valley Bank | 255 E River Park Circle Dr, St | FRESNO | CA | 300000 | 225000 | 23-09-2011 | 2011 | NaN | PLP | Guaranty | 6.00 | 120 | 621610.0 | Home Health Care Services | NaN | NaN | FRESNO | CA | FRESNO DISTRICT OFFICE | 22.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 3 | 6 |
| 604 | 20200930 | 7A | Mopho Group, LLC | 514 City Park Avenue, suite | New Orleans | LA | 70119 | Gulf Coast Bank and Trust Company | 200 St. Charles Ave | NEW ORLEANS | LA | 520000 | 390000 | 25-07-2013 | 2013 | NaN | PLP | Guaranty | 6.50 | 120 | 722511.0 | Full-Service Restaurants | NaN | NaN | ORLEANS | LA | LOUISIANA DISTRICT OFFICE | 2.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 29 | 6 |
| 636 | 20200930 | 7A | North Terrace PM LLC | 4344 Belleview Ave | Kansas City | MO | 64111 | Bank of the West | 180 Montgomery St | SAN FRANCISCO | CA | 100000 | 85000 | 23-01-2018 | 2018 | NaN | PLP | Guaranty | 7.25 | 120 | 531110.0 | Lessors of Residential Buildingsv and Dwellings | NaN | NaN | JACKSON | MO | KANSAS CITY DISTRICT OFFICE | 5.0 | CORPORATION | CANCLD | NaN | NaN | 0 | 0 | 0 | 6 |